Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save-As Option Disable | Excel Worksheet Functions | |||
how do I disable the option that keeps incrementing cells by 1? | Excel Worksheet Functions | |||
Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
How to disable smoothline option. | Charts and Charting in Excel | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |