On this computer I have Office 2007 and windows 7. Other computers have the same system. Some have vista, windows 8, windows 8.1 along with the same office 2007.
I have the same rather large excel 2007 spreadsheet on every one of these computers. They all run it great, except the this one.
I get the following error when loading the spreadsheet: Visual Basic Runtime Error # 32809. The code it refers to is:
Private Sub Workbook_Open()
Worksheets("Client").Activate
Application.WindowState = xlMaximized
End Sub
When I cancel the error, the code seems to run properly. i.e. the Client worksheet is the active sheet and the window is maximized. As I said, I only have this problem on this machine (Toshiba laptop, with windows 7 and office 2007)
I believe I have properly updated visual basic on this machine - but it acts like I might have not...
What is causing the error to run on this machine only? How can I stop it?
Thanks
Hank
I have the same rather large excel 2007 spreadsheet on every one of these computers. They all run it great, except the this one.
I get the following error when loading the spreadsheet: Visual Basic Runtime Error # 32809. The code it refers to is:
Private Sub Workbook_Open()
Worksheets("Client").Activate
Application.WindowState = xlMaximized
End Sub
When I cancel the error, the code seems to run properly. i.e. the Client worksheet is the active sheet and the window is maximized. As I said, I only have this problem on this machine (Toshiba laptop, with windows 7 and office 2007)
I believe I have properly updated visual basic on this machine - but it acts like I might have not...
What is causing the error to run on this machine only? How can I stop it?
Thanks
Hank