| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't let user close. Use macro button to close?
How can I force this? Can I?
I need to make sure the workbook is saved before it's closed, make sure it's not closed without being saved. I have a "Close" button that goes to a macro that saves. I thought of putting a save macro in as workbook.deactivate code, but then my button would be redundant. Should I just lose the button and stick with workbook.deactivate? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ability to close a worksheet and email using a macro button | Excel Discussion (Misc queries) | |||
| Macro to Prompt User to Close After Saving | Excel Discussion (Misc queries) | |||
| Close user form when button is pressed | Excel Programming | |||
| Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
| excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
Threaded Mode
