Thread: VBA MsgBox to inform users to enable macro options.

All,

I am looking for vba language that would active a message box saying "Please enable macros by clicking on the options button below the formula bar." I need this message box to appear as soon as the file is opened. Right now I am using:

Private Sub Workbook_Open()
MsgBox "Please enable macros by clicking on the options button below the formula bar."
End Sub

The code that I currently have only shows up AFTER you select options and not right when the spreadsheet is open.

Any help is greatly appreciated.

How do you hope to get code to run before the users enable code?

You need the reverse approach - a workbook with a prompt sheet that is only hidden by the macros running. See for example here.

My suggestion would be to create an opening page that activates with each close of the workbook. The opening page could have any form of letting the user know to enable macros. As it is, your code cannot fire until macros are enabled so it makes the message moot. I have the same issues with a workbook that is meant to be used corporate wide where I work and I made a page that shows the user where to click in case they don't know to do so.

Thanks for the input.

OEG0, I'm using the example in the link you shared but unfortunately, when it unhides all the sheets in the workbook after enabling the macros, it's unhiding some sheets that I want to keep hidden and not share with the users. Is there a way to use the same example and have it only unhide specified sheets by their tab name once the macros are enabled? That would help tremendously.

Thanks.