Solved: Prompt to enable macro

[Emoncada]

I have a UserForm that is needed to prompt on opening the Workbook.

What I would like is when the workbook is open have a prompt asking them to enable macro (Yes Or No) and if Clicked "Yes" Enable Macros and start form

If clicked "No" close the workbook.

Any help would be great.

Thanks

[Emoncada]

Ok just thought about this and this won't work because you can't have a prompt without macro's enable.

Any other suggestions?

[Emoncada]

Is it possible once macro's are enabled to start a UserForm?

[GTO]

Try the Open event in ThisWorkbook:

Private Sub Workbook_Open()
UserForm1.Show vbModal
End Sub


hope that helps,

Mark

[Emoncada]

Thanks GTO