View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clare Clare is offline
external usenet poster
 
Posts: 32
Default 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