PDA

View Full Version : Issues showing userform with Excel 2000 (service pack 3)



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: )

feathers212
04-30-2007, 09:58 AM
I get a "Run-time 1004: application-defined or object-defined error"

Jan Karel Pieterse
04-30-2007, 09:24 PM
Might be good to move your code to a normal module and call the new sub from Workbook_Open.

feathers212
05-01-2007, 06:57 AM
I spoke with our IT guy yesterday and he informed me that they planned on upgrading software on the computers. So I'm going to just hold off on this for a few days until everything is upgraded to Excel 2003 (will make my life so much easier....just wish I had known sooner:doh: )

Bob Phillips
05-01-2007, 10:07 AM
Heather, Can you try Jan Karel's suggestion? If it works, it would be useful a) to know, and b) for the archives.