Disable SAVE, SAVE AS & CTRL+S once Macro is executed

hello friends,

I got this workbook comprising of about 30 sheets. all sheets run macros and all sheets are locked except for some cells in each sheet where data entry is required in order to get the out put.

about 4 sheets got BUTTONS (created using format control).

my requirement is to disable the SAVE, SAVE AS & CTRL+S functions once either of these buttons are pressed.

for this purpose, could a textbox appear with a sign "THIS FILE CANNOT BE SAVED - PRESS OK TO EXIT". so once OK is pressed the file exits without saving.

this textbox should appear in all 30 sheets, whilst this textbox is on we should be able to work on other sheets as well. but the bottom line is that the workbook cannot be saved and this too only if either one of the 4 BUTTONS are pressed.

the 4 BUTTONS are assigned to different macros.

looking forward to your assistance.

thank you
regards
rizvi

Hi 6StringJazzer,

Thanks Mate. YES! it's the MsgBox, of course!
Now, instead of BUTTONS, i could create MsgBoxes (1 per each sheet of 4 sheets as explained in my initial msg). so in all 4 sheets the MsgBox will initially read "PRESS TO PROCESS LETTERS" with OK button

so in case say SHEET3 i press the OK button the process is done and another msg in the same MsgBox should appear as "THIS FILE CANNOT BE SAVED - PRESS OK TO EXIT" and with another OK button to also appear in the same MsgBox. if OK is pressed, then the file es exited without saving.

say SHEET 6 also got a MsgBox, and i want the same process to happen in this sheet as well. likewise all 4 sheets should have this MsgBox as each sheet has different functions with the MsgBox but once OK is pressed all 4 MsgBoxes got the same function.

plsd to hear
thanks / rizvi

Hi Mate,

I have taken the time now to work on your suggested macros and the magic happened! it worked!!!
many thanks for your help and i have given you a rep whilst also closing this thread as solved.

all the best to you.
Rizvi