MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro run problems


Posted by sean shanley on November 12, 2001 2:27 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:31 PM

see below

Posted by Damon Ostrander on November 13, 2001 9:52 AM

Hi Sean,

In Excel 97 and 2000, the macro security is not changed from Tools -> Options. It is changed from the Tools -> Macro -> Security menu. Set security level to Medium or Low.

Damon

Posted by Damon Ostrander on November 13, 2001 9:58 AM

Sean,

Why not just start a loop that loops indefinitely until the new data shows up? If the cells already contain (old) data, simply clear it before starting the loop, then in the loop test for whether the cell or cells are empty and as soon as the cells contain data jump out.

Damon