how to enforce to run macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
hi gord dibben
can u elaborate on the dummy sheet? can also show me the steps to do this?
thanks alot
 
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
 
Back
Top