gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
The following code works fine on my 64bit Excel but not on 32bit: I discovered it I went ahead and stopped the code but then reran it immediately the code would work and perform like it should. Therefore I had to add the Error Resume option and was hoping that it would go ahead and complete the code but it doesn't. I still have to manually run this macro again and all is well.
This code is in "This Workbook"
Any thoughts on how to get this to work properly?
This code is in "This Workbook"
VBA Code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Application.WindowState = xlMaximized
On Error Resume Next
Sheets("Category Review").Select
Range("A1:K12").Select
ActiveWindow.Zoom = True
Range("A1").Select
Application.ScreenUpdating = True
On Error GoTo 0
End Sub
Any thoughts on how to get this to work properly?