Enabling Macros
Is there a way to force Excel to open allowing Macros and not giving the
user the option to disable them? |
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? |
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? |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com