No, what I was referring to was a public global variable. I was suggesting a
variable as it would automatically re-initialise on next opening. The
problem with using a cell is that you would need to clear it before closing
the workbook.
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bob,
>
> Do you mean like testing the content of a cell or something?
>
> Thanks,
>
> On Jan 28, 7:27 pm, "Bob Phillips" <bob....@somewhere.com> wrote:
> > Why not just set a flag in the code after the save that gets tested in
the
> > macros, and the exit immediately if set.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (there's no email, no snail mail, but somewhere should be gmail in my
addy)
> >
> > <y...@hotmail.com> wrote in
messagenews:(E-Mail Removed)...
> >
> >
> >
> > > HI,
> >
> > > I am trying to save as an excel workbook with macros but when the user
> > > will open it after the save as i dont want the macros to work.
> >
> > > I have a form that kicks in in the Workbook_Open event, i dont want
> > > this event to occur after the save as.
> >
> > > I know about Application.EnableEvents=False but if i use it it will
> > > disable the macros all the time, i need to disable it only when the
> > > user opens the copy after the save as.
> > > I googled for it but couldnt find anything.
> >
> > > Thanks,- Hide quoted text -- Show quoted text -
>
|
Similar Threads
