[SOLVED:] Disable Enable/Disable Macro window [Archive]

malik641

07-31-2005, 11:25 AM

Is there a way to have a workbook open that has macros to default to "Enable Macros" instead of the pop-up window?? And for it only to be ONE specific workbook? and not as a setting for all other workbooks.

Ken Puls

07-31-2005, 12:37 PM

Hi there,

You mean you want to leave your security to prompt for any workbooks except a specific one?

If you are using XL 2000 or above, you could use SelfCert.exe to create a digital signature for yourself. Install it, and it won't prompt you again.

mdmackillop has a good article on how to do this here (http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=3).

HTH,

malik641

07-31-2005, 12:57 PM

Awesome! Exactly what I was looking for....man I love this forum!!!!
Thanks kpuls!

Ken Puls

07-31-2005, 02:00 PM

Awesome! Exactly what I was looking for....man I love this forum!!!!
Thanks kpuls!

Great! Glad to be of help!

Is the question definately solved then? If so, you know you can mark it such, yes? ;)

malik641

07-31-2005, 02:10 PM

Yes.:yes

chandansify

07-31-2005, 09:16 PM

Hi there,

You mean you want to leave your security to prompt for any workbooks except a specific one?

If you are using XL 2000 or above, you could use SelfCert.exe to create a digital signature for yourself. Install it, and it won't prompt you again.

mdmackillop has a good article on how to do this here (http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=3).

HTH,

Thanks...:thumb

Zack Barresse

08-01-2005, 09:00 AM

Dun, dun-du-daa! Super Ken to the rescue!!! :D

Ken Puls

08-01-2005, 10:30 AM

Dun, dun-du-daa! Super Ken to the rescue!!! :D

:rotlaugh: