do a search of this newsgroup in Google groups. There are plenty of
approaches to this.

http://groups.google.com/groups?as_q...ng&lr=&hl=e n


or
http://groups.google.com/advanced_group_search?hl=en

search for force macro enable
group microsoft.public.excel.programming

--
Regards,
Tom Ogilvy

"Rich" wrote in message
om...
My project is to secure an excel workbook for distribution to remote
agencies.
I have worked out a code for date checking, and how to close excel if
dates are reached.

I could say the project is finished at this stage, having reached my
objective but like others I can't in good conscience regard this as
'finished'. Purely because there are countless other security holes
which could be patched with macros if I could ject figure them out.

many ppl talk about forcing macros. I know now they can't literally be
forced, but we can persuade the user to use them.

Can someone please explain to me through the use of code, how to set a
dummy sheet (which I will have a message on, telling ppl to use
macros) while other sheets are hidden? And all this BEFORE macros are
given the chance to run??

Code for individually hiding sheets is relatively easy, but these are
macros. How are sheets hidden before macros are run?