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