Quite right Tom: I should have tested that before putting finger to
keyboard.
(Was that the case in earlier versions of Excel? How do you get a macro
to fire without a prompt?)

Regards
J

On Oct 23, 2:23 pm, Tom Ogilvy
wrote:
That is incorrect.
Either one would cause a prompt for enabling macros if either caused a
prompt.

--
Regards,
Tom Ogilvy



"WhytheQ" wrote:

Two ways I know of:

'no prompt will appear about enabling macros
Sub auto_open()
UserForm1.Show
End Sub

'a prompt will appear
Private Sub Workbook_Open()
UserForm1.Show
End Sub

Rgds
J

On Oct 23, 1:35 pm, Zaahir wrote:
Hi
how do i show a userform uponopening an excel workbook? Can it be done?
Regards- Hide quoted text -- Show quoted text -