I have a workbook that contains serveral formatting macros that I use when I
prepare it. I then post it to the company Intranet site for others to view.
Whenever anybody opens and then closes it, it asks them whether they want to
save it or not, even though no changes are made. I am assuming that it is
the presence of the macros that is causing this behavior. Is there a way to
disable the macros before I post it and then enable them when I need to
update it?

Thanks

It is not the mere presence of the macros that is causing that behavior.
Something in the workbook is actually changing something in a cell or other
area such as a header or footer - possibly an auto-updating field such as
getting the date in a sheet's cell or header.

Unless macro code actually runs and changes something, it is not the cause
of that prompt. If you have to manually call the macros either through Tools
| Macro | Macros ... or click a button or use a shortcut to activate them,
then unless the user is doing that, it is not the macros that are at issue.

You might try setting Calculations to not automatic in Tools Options
Calculate and see if that helps. But if your 'viewers' need to make changes
to it, then they'd have to use [F9] to see the results of changes they made
that may affect the results of formulas that are dependent on those changes.

"Tom" wrote:

I have a workbook that contains serveral formatting macros that I use when I
prepare it. I then post it to the company Intranet site for others to view.
Whenever anybody opens and then closes it, it asks them whether they want to
save it or not, even though no changes are made. I am assuming that it is
the presence of the macros that is causing this behavior. Is there a way to
disable the macros before I post it and then enable them when I need to
update it?

Thanks

Tom

If the macros are not event type code they will trigger no changes.

I suspect you have one or more volatile functions hanging around.

Could be a NOW() or TODAY()

List of volatile functions........

AREAS()
OFFSET()
CELL()
INDIRECT()
NOW()
TODAY()
RAND()

Any one or more of these would cause the workbook changes.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 13:35:15 -0700, Tom wrote:

I have a workbook that contains serveral formatting macros that I use when I
prepare it. I then post it to the company Intranet site for others to view.
Whenever anybody opens and then closes it, it asks them whether they want to
save it or not, even though no changes are made. I am assuming that it is
the presence of the macros that is causing this behavior. Is there a way to
disable the macros before I post it and then enable them when I need to
update it?

Thanks