Get Save Prompt when closing workbook immediately after saving workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dbKemp - 18 Jan 2008 19:40 GMT

I get a save prompt many times when I close a workbook with a lot of
vba code even though I just saved the workbook. Anyone know why this
could be happening?

Reply to this Message

Mike H - 18 Jan 2008 20:16 GMT

You code could me changing the contents of the workbook

> I get a save prompt many times when I close a workbook with a lot of
> vba code even though I just saved the workbook. Anyone know why this
> could be happening?

Reply to this Message

dbKemp - 18 Jan 2008 21:11 GMT

> You code could me changing the contents of the workbook
>
> > I get a save prompt many times when I close a workbook with a lot of
> > vba code even though I just saved the workbook. Anyone know why this
> > could be happening?

Mike,
Thanks. I thought about that, but couldn't find anything. After your
reply I looked at it from another angle and found a place where I am
setting a named range. Finding the source is just a start. Now I
have to figure out how to keep the functionality & get rid of the
prompt.

Reply to this Message