prevent creating a copy of file
 

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

prevent creating a copy of file
 

Not possible since the user can always bypass macros by starting in Office
safe Mode or with macros disabled.
--
Gary''s Student - gsnu200836


"terilad" wrote:

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

prevent creating a copy of file
 

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

"terilad" wrote:

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