Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimise unwanted windows
A workbook named 'DoorSchedule.xls' is used by others on different PCs. It
includes macros which close its own named worksheets and opens and arranges two at a time as required for each particular situation. When DoorSchedule is opened Option Explicit Sub create_menubar() .. End Sub generates the toolbar for the workbook containg buttons to arrange the windows. However, running these window arranging macrosresults in errors if there are other windows open. At first I though any other workbooks would have to be closed but I find it is sufficient to make sure the worksheets of other workbooks are minimised. 1 Can you suggest a macro which would minimise worksheets of any other workbooks than those of DoorSchedule? 2 I should also like the option of saving and closing any other workbooks. Francis Hookham |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted debug windows | Excel Discussion (Misc queries) | |||
Maximise and Minimise buttons | Excel Programming | |||
Minimise Excel after several minutes | Excel Discussion (Misc queries) | |||
Disabling Minimise/Restore Down buttons | Excel Programming | |||
Minimise Maximise Problem | Excel Programming |