Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub WView(ViewNb)
Application.EnableEvents = False On Error GoTo Gone Select Case ViewNb Case 1 With Application '.WindowState = xlNormal .Width = 680 .Height = 573 End With Case 2 With Application '.WindowState = xlNormal .Width = 763 .Height = 573 End With End Select Gone: Application.EnableEvents = True End Sub This wont work. The error message is displayed and error halts operation. Looked everywhere and experimented with a lot of variations. Thanks for your help. -- Jim at Eagle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming |