Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a Sub preventing users from saving a workbook, when
on worksheet "Scorecard" certain cells (cell ranges with percent values) are blank: G26:I26 Customer Weight AG26:AI26 L&G Weight G44:I44, Financial Weight AG44:AI44 Process Weight Also need a message box directing the user to the blank cell, saying which cells are blank: "A value greater than zero is required for Customer Weight." If more than one cell is blank, the message would include those cells too. Where would I put the Code? Thanks, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Event (BeforeSave) - How to test VBA code? Dave P. can you hear me now? | Excel Discussion (Misc queries) | |||
BeforeSave event | Excel Discussion (Misc queries) | |||
VBA - BeforeSave - NEED HELP | Excel Programming |