A button enables macros automatically

**abokhadiga** · 12-17-2009, 04:16 PM

Hi all,
I have written a macro that give two sheets. One is prompt to force user to enable macros, then the sheet prompt disappear. Second is the code sheet which has many formulas.

Now, I want to have a code for a button which enables macros automatically when the user press on it. Any suggestions?

Thanks in advance

**DonkeyOte** · 12-17-2009, 04:33 PM

You can not automate the enabling of macros - that would rather negate the point of the security in the first instance.

You should set your file up such that only one sheet is visible when the file is opened which provides instructions for enabling macros - use the Workbook_Open event to hide this sheet and unhide (veryhidden) the others such that if the file is opened with Macros enabled the instruction sheet is hidden and working sheets are visible.

For a more thorough explanation of this process see: http://www.cpearson.com/excel/EnableMacros.aspx

Please also note discussions as to how to circumvent security are not permitted on this board so should the thread head off in that direction appropriate action will be taken etc...

**abokhadiga** · 12-17-2009, 05:01 PM

That was actually what I did. Nevertheless, I aim to have a button in the first sheet (prompt) which enables macros when the user press on. Only, if available!

Thanks

**Marzuk** · 12-17-2009, 05:35 PM

As he explained, that is not possible.

There are other ways provided by Excel itself, which allow macros to run without a prompt. Cant say I've tested them with macros specifically disabled though.