I just ran into a similar (but not exact) problem with an office 2007 installation. Any word/excel doc would toss macro errors. Ended up doing a "change" install on office but added VBA and all the converters. That fixed it.
Might not apply to your issue, but since it wasn't really documented and is non-intuitive, it might be worth a try. *********************** Charlie Kaiser charl...@golden-eagle.org Kingman, AZ *********************** > -----Original Message----- > From: Robert Jackson [mailto:r...@walkermartyn.co.uk] > Sent: Tuesday, September 22, 2009 2:36 AM > To: NT System Admin Issues > Subject: RE: MS Excel 2003 Security Issue > > Bit more detail to add. > > Take the Excel 2003 spreadsheet and pop it on a Windows 2000 > server, change the Macro Security to "Medium" and everything is fine. > > Do the same thing under Windows 2003 server and the issues > are still there. > I've tried to generate a self certificate and apply that to > the VBA project contained in the spreadsheet, but this > doesn't work either. > > Any ideas? > > > > Regards, > Rab. > =========================================================== > Robert Jackson Phone: +44 (0) 141 332 > 7999 > Software Engineer Fax: +44 > (0) 141 331 > 2820 > Walker Martyn Ltd > 1 Park Circus Place Email: > r...@walkermartyn.co.uk > Glasgow G3 6AH, Scotland Web: > http://www.walkermartyn.co.uk > =========================================================== > > -----Original Message----- > From: Charlie Kaiser [mailto:charl...@golden-eagle.org] > Sent: Friday September 2009 14:13 > To: NT System Admin Issues > Subject: RE: MS Excel 2003 Security Issue > > A few things... > First, you might have to change the setting twice. A small > E2003 quirk... > > Some good info on the registry settings for this: > http://www.pcreview.co.uk/forums/thread-3301246.php > > You can set this with GP. Check this out... > http://www.microsoft.com/downloads/details.aspx?FamilyID=ba8bc > 720-edc2-4 > 79b- > b115-5abb70b3f490&displaylang=en > > In Local Computer Configuration \ Admin. Templates \ Microsoft Office > 2003 \ > Security Settings > "Automation Security" - Enabled - "Macros Enabled" > "Excel: Macro Security Level" - Enabled - "Low" or "Medium" > > Also, if you're running onecare, that can affect it as well... > > HTH... > > *********************** > Charlie Kaiser > charl...@golden-eagle.org > Kingman, AZ > *********************** > > > -----Original Message----- > > From: Robert Jackson [mailto:r...@walkermartyn.co.uk] > > Sent: Friday, September 18, 2009 4:58 AM > > To: NT System Admin Issues > > Subject: MS Excel 2003 Security Issue > > > > We have a Windows 2003 SP2 (Std Edition) Terminal Server. > > What we are finding is that users cannot open an Excel 2003 > > spreadsheet (containing > > macros) without an error occurring stating macros have been > disabled. > > > > I've tried changing the security level within Excel 2003, but no > > difference. > > > > We haven't got any trusted certificates setup. I'm assuming it's a > > permissions issue, but I just can't determine where to look? > > > > > > Regards, > > Rab. > > =========================================================== > > Robert Jackson Phone: +44 > (0) 141 332 > > 7999 > > Software Engineer Fax: +44 > > (0) 141 331 > > 2820 > > Walker Martyn Ltd > > 1 Park Circus Place Email: > > r...@walkermartyn.co.uk > > Glasgow G3 6AH, Scotland Web: > > http://www.walkermartyn.co.uk > > =========================================================== > > > > > > ************************************************************** > > ********** > > The information in this internet E-mail is confidential and is > > intended solely for the addressee. Access, copying or re-use of > > information in it by anyone else is unauthorised. Any views or > > opinions presented are solely those of the author and do not > > necessarily represent those of Walker Martyn Ltd or any of its > > affiliates. If you are not the intended recipient please contact > > administra...@walkermartyn.co.uk > > > > Walker Martyn Ltd, company number SC197533. Company is > registered in > > Scotland and has its registered office at 1 Park Circus > Place, Glasgow > > G3 6AH, UK. > > **************************************************************** > > > > > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource > hog! ~ ~ > > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > > ~ Finally, powerful endpoint security that ISN'T a resource > hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > ~ Finally, powerful endpoint security that ISN'T a resource > hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
