Prevent to click save button

Hi,

I created one Excel file (Shared file).

But, I just want to let the user access it without saving the values in the worksheets.
How can I prevent the user to save the values on the worksheets? Because if the user click on save button on the menu bar, then the values will be updated on the worksheets, if any other user access the file at the same time, then they will see the values, because I am using Shared mode (I used it because I want to skip the message when opening file "Read only........")

Hi, paste this in to the ThisWorkBook module:

Please Login or Register  to view this content.

it will prevent save and save as.

Regards,
SImon

can I just prevent to save, whereas SaveAs is allowed?

Try removing the "If SaveAs..." statement!