MrExcel Publishing
Your One Stop for Excel Tips & Solutions error

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

i get an automation error in Excel 2000 when using the command 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
end sub

for closing workbook :

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

hope these helps. cheers