Disable Macro Option
Does anyone know how I can set my workbook to open without
giving the user the option of enabling or disabling the macros I created? |
Disable Macro Option
Hi
you can't do this in your workbook as this is a security feature. The user may set his security level to 'Low' but this could/would have security drawbacks -- Regards Frank Kabel Frankfurt, Germany Pete wrote: Does anyone know how I can set my workbook to open without giving the user the option of enabling or disabling the macros I created? |
Disable Macro Option
You can't. Just think about the field day virus writers would have if you
could do that. A commonly used technique is to make the key sheet hidden, and have some workbook open code that makes it visible. Put some text on another sheet warning the users about disabling macros and save it with this sheet active. Not foolproof, but it helps. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Pete" wrote in message ... Does anyone know how I can set my workbook to open without giving the user the option of enabling or disabling the macros I created? |
All times are GMT +1. The time now is 11:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com