| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Statement Before Save
I want a message box to pop up if there are any orange cells on sheet1. The click event will be BeforeSave. I have some conditional formattin that changes a cell to orange. I don't want the user to be able t save if there is orange on the sheet. The orange can appear i A1:F6000. What does the If statement look like for this scenario? Thanks -- scottnshell ----------------------------------------------------------------------- scottnshelly's Profile: http://www.excelforum.com/member.php...nfo&userid=730 View this thread: http://www.excelforum.com/showthread.php?threadid=57053 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| How to diasble save and save as menu but allow a save button | Excel Programming | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
![scottnshelly[_66_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
