Disable save and save as upon opening a certain workbook

[Tino XXL]

Hi all,

I have a macro enabled workbook, and I want it to
prevent the user from saving the file in any way. Canon anyone pls tell me how to disable the save and save as functionality using vba in the Auto_Open subroutine?

Thanks in advance.

Tino XXL

[Steffen Thomsen]

You have to look into the event called "Worksheet_BeforeSave"

This will do what you ask, but it's easy to surcomvent

Please Login or Register  to view this content.

You can read a little more about the event here

http://msdn.microsoft.com/en-us/library/ff840057.aspx