MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro run problems


Posted by sean shanley on November 12, 2001 2:13 PM

I need help please!!

I have an excel workbook with many sheets prepared for presentation. I created many buttons on a page for navigating to and from each worksheet- this works well

problem
I gave the file to the presenter to present on another pc and it wont work.

When the presenter opens the file the macro enable/disable prompt doesnt appear. I thought that this was just because it was turned off in Tools/Options under general tab "macro virus protection" not checked. But here is the problem this option is not visible at all in the general tab

When i told the presenter to record a simple macro and and try running it the message was that this was disabled.

where if not in options at teh general tab could this have been disabled and why is the check box missing.

I need to know asap and would appreciate any help
thanks

Ps
its either excel 97/2000 on the PC that wont operate the macros and the file was created on 97
I thought then that use of macros was and add in of some sort and wasnt loaded on this pc however when i checked my own pc this shows no add in thta could be related


Posted by faster on November 12, 2001 2:29 PM

Could be a 97 to 2000 issues. On the problem PC in a blank workbook check:

TOOLS/MACROS/SECURITY

I think 2000 defaults to allowing no macros. The user
must change this option. I hope this helps.

Posted by sean shanley on November 12, 2001 2:32 PM

How do I change this option? when the checkbox is missing in the tools/options general tab?

Posted by faster on November 12, 2001 2:41 PM

In 2000 TOOLS/MACROS/SECURITY not in the options section.