Get Save Prompt when closing workbook immediately after savingworkbook

  • Thread starter Thread starter dbKemp
  • Start date Start date
D

dbKemp

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?
 
You code could me changing the contents of the workbook
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA editor doesn't prompt to save changes, doesn't save 3
Need help with Workbook_BeforeClose event 8
prompt to save when already saved 1
"Save" macro problem, still prompted to save when closing workbook (?) 8
close/open workbook without prompts 5
All Workbook Saved except This Workbook 3
How can just opening & closing a workbook prompt the Save? dialog? 4
Close workbook without being prompted to save in VBA 5

Back
Top