| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save VBA without saving the workbook?
I have some vba code that requires 4 cells to be completed on BeforeSave.
The code works great, but I need to be able to save the code without having to complete the 4 fields in the worksheet because I want users to open the worksheet with the 4 cells empty. I originally created some WorksheetOpen code that emptied the 4 fields. But, I need users to be able to complete all 4 fields and save and reopen again with the fields complete so that code won't work. This is driving me nutty. Any suggestions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close workbook without saving or promt to save | Excel Discussion (Misc queries) | |||
| Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
| Macro file save as, saving sheet not workbook | Excel Programming | |||
| Workbook.Save not saving the updates | Excel Programming | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
Threaded Mode
