| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Worksheet When Workbook Is Saved
Hi, could someone tell me how to do this in vba ?
When a user tries to save the workbook, for Sheet1 if any cell in column A (A3 until the last row) equals "3" or column B (B3 until the last row) equals "Calculus" then prevent the workbook from being saved & prompt a msgbox if the corresponding cell in column C , F & H is blank. Thanks ! Rgds, Clare |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I hyperlink to a worksheet tab in workbook saved as html? | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook continued | Excel Discussion (Misc queries) | |||
| How can I see a copy of a saved workbook before I saved it again? | Excel Worksheet Functions | |||
| When saving workbook only the first worksheet gets saved. | Excel Worksheet Functions | |||
Threaded Mode
