Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have code to change my appplication.width from double width to
single width. The code works fine with the exception of when I don't have a workbook actually open. Is there a way to test whether any workbooks are currently open? Then maybe I can skip the line that fails. Here is my code. It is failing at the 2nd line when there isn't a workbook open. Sub TOOLBAR_MK_SCRN_SINGLE_WIDTH_MOVE_RIGHT_TO_LEFT() 'SHRINKS SIZE OF DOUBLE WIDE SCREEN TO SINGLE WIDE SCREEN AND THEN MOVES ACTIVEWORKBOOK 'FROM RIGHT SIDE TO THE LEFT SIDE. If Application.WindowState = xlMaximized Then Application.WindowState = xlNormal If ActiveWindow.WindowState = xlMaximized Then ActiveWindow.WindowState = xlNormal <-fails here ActiveWindow.WindowState = xlNormal With ActiveWindow .Top = 0 .Left = -2 End With Application.Width = 958 ActiveWindow.Height = 654 Application.Height = 768 End Sub Thanks in advance. Chet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Detect if an excel file is open | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
how to detect if user has a dialogbox open | Excel Programming | |||
How to detect Acrobat Distiller open | Excel Programming | |||
Detect if file is open | Excel Programming |