Prev: How to access macros via tool buttons?
Next: Formatting Text to Numbers for Dates
From: Gary''s Student on 27 May 2010 15:53
I would include a macro that runs automatically when your workbook is opened.
The macro would save the state of iteration and then setup iteration
according to your model's needs.

Another macro would run automatically when the workbook is closed. The
second macro would restore the state of iteration.
--
Gary''s Student - gsnu201003


"Paolo" wrote:

> Have a problem. I have to create a model which include some iterative
> calculation, but the model is addressed to a large number of users and i
> don't want the error message for circular references to appear when they open
> it.
> As far as i understand i can't create a template because it would be saved
> on my machine. The file needs to work as it is on every computer.
> I have noticed that if a user has already another Excel file open (without
> the iteration box flagged) and they open my file the error message appears,
> if they lunch my file and Excel is not opened is ok.
>
> Any idea? Thanks!
From: Paolo on 27 May 2010 17:20
Thank you very much....I've actually thought about it but could find a way to
run a macro automatically when the file is opened. I have actually created a
macro for the iteratio to help the users eliminate the issue but it would be
great if it could be run at start without any interaction from the users.
How can i set up this macro?


"Gary''s Student" wrote:

> I would include a macro that runs automatically when your workbook is opened.
> The macro would save the state of iteration and then setup iteration
> according to your model's needs.
>
> Another macro would run automatically when the workbook is closed. The
> second macro would restore the state of iteration.
> --
> Gary''s Student - gsnu201003
>
>
> "Paolo" wrote:
>
> > Have a problem. I have to create a model which include some iterative
> > calculation, but the model is addressed to a large number of users and i
> > don't want the error message for circular references to appear when they open
> > it.
> > As far as i understand i can't create a template because it would be saved
> > on my machine. The file needs to work as it is on every computer.
> > I have noticed that if a user has already another Excel file open (without
> > the iteration box flagged) and they open my file the error message appears,
> > if they lunch my file and Excel is not opened is ok.
> >
> > Any idea? Thanks!
 | 
Pages: 1
Prev: How to access macros via tool buttons?
Next: Formatting Text to Numbers for Dates