PDA

View Full Version : Enable Macros when opening Worksheet



M22664
04-02-2010, 06:35 AM
There's a worksheet I have that has values in column "C". I use the "ClearContents" code to clear out the cells when you open the worksheet, but first I still have to click "Enable Macros" to get it to work. I know I can change the security level to always enable macros, but I don't want to with every worksheet. Is there a code I can use to Enable Macros only for this one sheet?

Thanks

Ago
04-02-2010, 06:51 AM
http://office.microsoft.com/en-us/excel/HA012317811033.aspx

Bob Phillips
04-02-2010, 06:57 AM
No you can't, it would make the security pointless.

You could make it an addin, sign it, or if 2007, move it to a trusted location. Other than that you are stuck with it.