Userforms
 

Hi
how do i show a userform uponopening an excel workbook? Can it be done?
Regards

Userforms
 

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

Userforms
 

Private Sub Workbook_Open()
Userform1.show
End sub

this is the workbook open event and is fired when the workbook is opened.
It must be located in the thisworkbook module

See Chip Pearson's page on events for an overview if your are not familiar:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Zaahir" wrote:

Hi
how do i show a userform uponopening an excel workbook? Can it be done?
Regards

Userforms
 

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

Userforms
 

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 -