Me too. Strange.

Does this happen with every workbook you use, or just one? If you haven't
yet, create a new workbook, put some code in the Sheet1 module and save it.
Run the add-in code on that test workbook and see if you get the same
results.

I can't think of what might cause it to think there are macros that would be
eliminated by a UI save (and not a VBA save.)

Another thing you might try (although very kludgy), is to put the save and
close operations in another macro. Then use OnTime to call that macro 1
second after the main macro runs. Possibly giving it a second to catch up
will do the trick.

If none of that works, you can feel free to email me the add-in and a
workbook on which you know it fails. I can test it on my system and see if
it's add-in, workbook, or other related.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"KimberlyC" wrote in message
...
I'm using Excel 2000