Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Enabling Macros
Is there a way to force Excel to open allowing Macros and not giving the
user the option to disable them? |
#2
|
|||
|
|||
I don't think so. The best solution for this is probably to have excel open
with a warning page if the user chooses to disable macros. Have all the other sheets hidden and protect the worksheets/workbook and VBA code with passwords. The really determined user may still be able to crack your protection but most will take heed of your message on the warning page and reload with macros enabled. "Old Music Lover" wrote: Is there a way to force Excel to open allowing Macros and not giving the user the option to disable them? |
#3
|
|||
|
|||
Sort of. Try this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=379 ******************* ~Anne Troy www.OfficeArticles.com "Old Music Lover" wrote in message link.net... Is there a way to force Excel to open allowing Macros and not giving the user the option to disable them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros while the sheet being protected ! | Excel Discussion (Misc queries) | |||
Opening a file and enabling macros automatically | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Worksheet Functions |