General discussion

Locked

Windows XP and Excel'97 macros

By Mozster ·
I have a user running excel 97 under Windows XP and when they open a sheet that contains any form of macros it gives them the following "Permission to use object denied". Sheets without any kind of macros open fine.
They open fine on other workstations running the same OS and Excel 97 as well.
Any ideas if this is a workstation/Excel setting somewhere.
I've tried turning off Excel macro virus protection under Tools Options.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Maevinn In reply to Windows XP and Excel'97 m ...

I'm not an my XP machine right now, so can't give you exact details, but that sounds like part of the XP virus/spyware/firewall. Open up the Windows protection and tell it to prompt you before allowing macros.

Other option--make sure Office is fully patched!

Collapse -

by Mozster In reply to

Poster rated this answer.

Collapse -

by robo_dev In reply to Windows XP and Excel'97 m ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;280829

This problem occurs when the document contains a control, and the user's %homedrive% in the user profile points to a read-only share or directory.

Controls in Office 97 products need to create an .exd file in the Windows NT user's %homedrive% directory.

Collapse -

by Mozster In reply to

Poster rated this answer.

Collapse -

by ComputerCookie In reply to Windows XP and Excel'97 m ...

Nothing to do with anything suggested previously.

The '.doc' file extension has previously been exploited with 'macro's deployed using this file extension'. After a recent 'MS upgrade' i found that Outlook opened with a warning regarding macro's. Subsequent changes to 'Macro Security' settings removed this warning.

This is just an example of 'MS' changing your settings to place the burden of "malware" on the user.

You must realise that every time you allow your computer to deploy upgrades that the upgrade may change your settings to reflect the security level MS feels that people who are unable to reverse these settings should have employed.

Obviously you fit this bill!

If you wish to know how you can do this
Email me.

Collapse -

by Mozster In reply to

Poster rated this answer.

Collapse -

by Mozster In reply to Windows XP and Excel'97 m ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums