Excel Workbooks and VBA

Question

I have an Excel workbook that I need to put some VBA code into. Unfortunately, our security policies are to disable macros with notification.

However, when I put the code into the Workbook_Open() event, it isn't triggered when I tell it to enable the content.

Can anyone assist?

Have you tried adjusting the settings, closing Excel, and then opening your workbook?

ma81xx · Answer 1 · 2011-10-21 13:46:27Z

up vote 0 down vote

answered Oct 21 '11 at 13:46

	I don't know that that's it or not. I can run macros, but there doesn't seem to be a workbook or worksheet event that fires when I choose to enable the macros in the security dialog. – Jason Oct 21 '11 at 13:56
	If the macro security level is Medium, user is prompted to enable or disable unsigned macros. If macro is signed, it will run without prompt. – ma81xx Oct 21 '11 at 16:08

feedback

1 Answer