how to enforce to run macro

[Guest]

dear all,
how to make user must run macro even when they click disable macro thru medium security check. if they disable the macro then worksheet will not come out. how? pls help

 

[gilbert]

Hi ~X,

I have earlier posted the same question on this....I got the answer i
you cannot enforce to run Macro....coz that's the right of the user t
run the Macro, unless they set their security level to be the lowest.

HTH.

Rgds,
Gilber

 

[Gord Dibben]

help

You cannot force users to enable macros.

The usual method of operation in this case is to have a dummy sheet with a
message informing users they have opened the workbook with macros disabled and
the workbook is useless to them.

The other sheets are hidden and will become visible only if they enable
macros.

For tips and info on code for this see this google search thread.

http://snipurl.com/4qfg

Gord Dibben Excel MVP

 

[Guest]

hi gord dibben
can u elaborate on the dummy sheet? can also show me the steps to do this?
thanks alot

 

[Frank Kabel]

Hi
1. Just create a sheet of your like which shows some warning messages
that the user has to enable macros in order to use this spreadsheet.
2. Hide all your other sheets (including a password if you like)
3. Protect this dummy sheet and the entire workbook.

Place code (as describe in the link Gord gave you) in your workbook
events