| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I? Get Excel to do something when I close a workbook
I'm trying to write two seperate macros to make changes to a workbook
when I open it and close it. When I open the workbook I want to go to fullscreen - which I've managed to do. However! When I close the workbook I want to cancel the fullscreen option. I've tried several things including the WorkBookBeforeClose sub. I can get Excel to make the changes when I write and run a macro to close the workbook. But when I use the Close function in the File menu, Excel stays in fullscreen mode!! Quite frustrating! Can anyone help?? Many thanks. Andrew. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exiting excel ONLY the workbook will close | Excel Discussion (Misc queries) | |||
| Close Workbook in Excel | Excel Discussion (Misc queries) | |||
| close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
| Option in Excel to save a close a workbook inactive for 5 minutes | Excel Discussion (Misc queries) | |||
| Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
Threaded Mode
