Discussion Locked

Windows XP and Excel'97 macros

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

7 replies

by maevinn

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!

by computercookie

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.

This discussion is closed to new replies.