Enable/disable macros on startup

T

Tobias

Hi, I have a strange problem. I have created a big excelfile, with a couple
of macros in it. We are a number of users that are using the file, (not at
the same time). The problem is that I sometimes are asked to disable/enable
the macros and sometimes they are just disabled withou me getting the chance
to choose. I have medium safety. I am the only one having this problem, the
other users are always promted to choose disable/enable.

Does anyone have a clue?

Thanks in advance,
Tobias
 
D

Dave Peterson

Are you sure that your macro security level is staying at Medium?

There have been a few posts that say that this setting goes back to High.
(Usually, it's a windows registry restriction by the corporate IT department).

Or...Any chance you're hitting the enter key twice when you used the File|open
dialog. Maybe the keyboard buffer has an enter key waiting for the next
opportunity--and that macro warning is eating it up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top