prevent creating a copy of file

[terilad]

Hi,

I am looking for a Macro to run so that users cant save as or create a copy
of a file in excel, I only want the user to use the save icon or when you
press the red cross for a popup to appear saying only save new changes in an
excel workbook

Can anyone please help me with this.

Many thanks

Terilad

 

[Gary''s Student]

Not possible since the user can always bypass macros by starting in Office
safe Mode or with macros disabled.

 

[JLGWhiz]

Why not use the Workbook_BeforeClose event Or Workbook_BeforeSave evemt to
make sure it gets saved to Excel.