It's a possible solution if you think that your users will be prepared to
trust all your macros, and it can make life easier for you with your own
code. You need to look for SelfCert.exe from memory. It should be in your
office folder.

Alternatively, you can put your code in an add-in, and once the user has
elected to load the add-in the macro warning on that file won't be shown.

Robin Hammond
www.enhanceddatasystems.com


"Valeria" wrote in message
...
Thanks!
It works very well...
just for curiosity: searching the posts, I have also found as an option
the
digital certificate, so that basically users will be prompted only once to
enable macros written by you.
With the premises that I do not know anything about this subject, is it
something you would also suggest?
Thanks!
Valeria



"Bob Phillips" wrote:

Valeria,

If you add a macro called Auto_Open, that runs when you open a workbook.

On the other point, the most common way of handling that is to have a
worksheet that puts up a message about disabling macros, and then hide
all
other sheets. In your auto-open macro, hide this sheet and unhide the
rest.
If they disable macros, they will see this sheet, if they don't, they
will
not. Not foolproof, b ut a technique.

--
HTH

-------

Bob Phillips
"Valeria" wrote in message
...
Dear experts,
is there a way I can force users to enable macros when they open a
certain
workbook, or at least provoke a warning message if they disable them?
Thanks!
Best regards,
--
Valeria