show Userform when excel opens

[dimitri]

Hi,
I'm trying to have a userform (SaveAs) show when my woorkbook is open. the code I have is below.

Private Sub Workbook_Open()
SaveAs.Show
End Sub

I keep getting an error message saying "Expected function or variable". Any help would be appreciated. Thanks.

 

[Colin Legg]

The workbook class has a SaveAs method which is conflicting with the name of your userform (the code you posted is in the ThisWorkbook class module). Change the name of your userform by giving it a prefix of a commonly used convention. These two are both acceptable:

frmSaveAs
ufmSaveAs

Using a prefix convention helps to avoid conflicts with existing members or keywords.

 

[dimitri]

Ahh, that makes sense. I changed name and it works now. Thanks for the help.