File,Save run a macro

[officeuser1]

I have a macro running when a user clicks the File Save menu option. This is
a template for many people to use. So I can't let them save the template.
However, they can do a File SaveAs to a new file. Once this is done however,
if another person brings up the template. The Macro is no longer attached to
file save. If the same user brings up the template, File Save is attached to
the macro on the previously saved file. In other words. I have a file
called Template. I have a macro run when someone does a file same. It is
called DontSave. A person does a file save as to a file called Newfile then
closes it. They then bring up the template again. If you look at the
properties for File Save, the macro it is referencing is the one in NewFile.
If a new person brings up the template, File Save is not attached to a macro
at all. Does anyone know how to make sure File Save always references the
macro on the current worksheet?

[ADG]

Hi

try looking at the approach in the below link to VBA Forum

http://forums.microsoft.com/MSDN/Sho...25506&SiteID=1

This uses the Beforesave event to trap saving and give control to a user
defined macro
--
Tony Green


"officeuser1" wrote:

> I have a macro running when a user clicks the File Save menu option. This is
> a template for many people to use. So I can't let them save the template.
> However, they can do a File SaveAs to a new file. Once this is done however,
> if another person brings up the template. The Macro is no longer attached to
> file save. If the same user brings up the template, File Save is attached to
> the macro on the previously saved file. In other words. I have a file
> called Template. I have a macro run when someone does a file same. It is
> called DontSave. A person does a file save as to a file called Newfile then
> closes it. They then bring up the template again. If you look at the
> properties for File Save, the macro it is referencing is the one in NewFile.
> If a new person brings up the template, File Save is not attached to a macro
> at all. Does anyone know how to make sure File Save always references the
> macro on the current worksheet?

[officeuser1]

Thank you. While that did not answer the question, it pointed me to a better
solution. I did not know that you could check to see if the saveAS box would
open. I used that instead. Thanks again.

"ADG" wrote:

> Hi
>
> try looking at the approach in the below link to VBA Forum
>
> http://forums.microsoft.com/MSDN/Sho...25506&SiteID=1
>
> This uses the Beforesave event to trap saving and give control to a user
> defined macro
> --
> Tony Green
>
>
> "officeuser1" wrote:
>
> > I have a macro running when a user clicks the File Save menu option. This is
> > a template for many people to use. So I can't let them save the template.
> > However, they can do a File SaveAs to a new file. Once this is done however,
> > if another person brings up the template. The Macro is no longer attached to
> > file save. If the same user brings up the template, File Save is attached to
> > the macro on the previously saved file. In other words. I have a file
> > called Template. I have a macro run when someone does a file same. It is
> > called DontSave. A person does a file save as to a file called Newfile then
> > closes it. They then bring up the template again. If you look at the
> > properties for File Save, the macro it is referencing is the one in NewFile.
> > If a new person brings up the template, File Save is not attached to a macro
> > at all. Does anyone know how to make sure File Save always references the
> > macro on the current worksheet?