| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for Not Allowing to Save without first completing fields
I have created a spreadsheet (more like a template) that will be filled out
by employees in our company. I want the user to be unable to save the spreadsheet if certain cells have been left blank. Years ago, I created a macro in VBE, that would not allow the user to save the workbook if the cell was left blank, and brought up a pop up telling then why they couldn't save. Any help with the macro would be greatly appreciated. Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro to Save Copy of File to New Location | Excel Discussion (Misc queries) | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
| save an excel file in fixed length records whose fields are blank | Excel Discussion (Misc queries) | |||
| help with macro to save repeating data entry | Excel Discussion (Misc queries) | |||
Threaded Mode
