feathers212
04-30-2007, 09:39 AM
I have a file that when opened is supposed to show a user form called "Information" using the basic
Private Sub Workbook_Open()
Information.Show
End Sub
I have no issues with this working until I get to the computers with Excel 2000 (9.0.6926 SP3). I've read that there was some kind of issue with this happening......but from what I read, service pack 3 was supposed to take care of the whole run-time error associated with this.
Any thoughts? If absolutely necessary, I can probably have the Excel version updated to like Excel 2003.
Also, any updated coding solutions would need to work with Excel 2002, Excel 2003, and Excel 97 (yes......we have a wonderful assortment of Excel versions to choose from:think: )
Private Sub Workbook_Open()
Information.Show
End Sub
I have no issues with this working until I get to the computers with Excel 2000 (9.0.6926 SP3). I've read that there was some kind of issue with this happening......but from what I read, service pack 3 was supposed to take care of the whole run-time error associated with this.
Any thoughts? If absolutely necessary, I can probably have the Excel version updated to like Excel 2003.
Also, any updated coding solutions would need to work with Excel 2002, Excel 2003, and Excel 97 (yes......we have a wonderful assortment of Excel versions to choose from:think: )