Workbook Open Event help

[Hashiru]

Hi every one, I have just started scripting in vba, and I am faced with the problem of making the macro option dialog box more prominent than it is default in excel 2007. I have read that I cannot change the ribbon.
Instead what I want to do is to creat an event macro: workbook_open() and the code for it is to display the macro options dialog box to make it more prominent for others to notice that the workbook contain a macro. I have research the vba help with the excel dialog boxes and constants for these dialog box but the macro contain a bug and cannot run this line:

Application.Dialogs(xldialogMacroOptions).Show

From help I note that I need to specify some(an) argument for show but do not know how to do this. Can you show me how to completely do the event handler Private Sub Workbook_Open()
Thanks for your help in advance

 

[VoG]

Sorry, you cannot programatically change the macro security settings (for obvious reasons).

 

[Hashiru]

Thanks.

 

[Hashiru]

Can you please tell me why they allow the display of the dialog

Application.dialogs(xldialogOpen).show
Application.dialogs(xldialogSendMail).Show

but not

Application.dialogs(xldialogMacroOptions).show but they listed it as one on the excel dialog on the help system

Thanks

 

[shg]

You need to specify a macro name:

Application.Dialogs(xlDialogMacroOptions).Show "myMacro"

 

[shg]

To see the same dialog as when you press Alt+F8 (compliments of Andy Pope),

Application.CommandBars.FindControl(ID:=186).Execute

 

[tusharm]

That's a good intention. However, using code to show the dialog box is possible only *after* the consumer allows the macros to run in the first place!

And, of course, after s/he OKs macros there's no point is displaying the dialog box!

Hi every one, I have just started scripting in vba, and I am faced with the problem of making the macro option dialog box more prominent than it is default in excel 2007. I have read that I cannot change the ribbon.
Instead what I want to do is to creat an event macro: workbook_open() and the code for it is to display the macro options dialog box to make it more prominent for others to notice that the workbook contain a macro. I have research the vba help with the excel dialog boxes and constants for these dialog box but the macro contain a bug and cannot run this line:

Application.Dialogs(xldialogMacroOptions).Show

From help I note that I need to specify some(an) argument for show but do not know how to do this. Can you show me how to completely do the event handler Private Sub Workbook_Open()
Thanks for your help in advance