userform1.show error

Posted by doug on January 29, 2001 4:57 PM

i get an automation error in Excel 2000 when using the command userform1.show. show.userform1 will not work either. The first of these commands work fine in Excel 97, does anyone know what i can do?

Posted by Azri on January 30, 2001 2:55 AM

So try these :

for open workbook :

Private Sub Workbook_Open()
load userform1
userform1.show
end sub

for closing workbook :

private sub workbook_beforeclose(cancel as boolean)
load userform1
userform1.show
end sub

hope these helps. cheers