Using XL2K, I have a "New Month" button on the Worksheet Menu Bar that,
when clicked, runs a routine that, among other things, copies all sheets to
a new workbook. Problem is, that button duplicates (others don't, only this
clicked one). It stays there until I deactivate to book through various
means (opening/closing new workbook, closing/reopening the file), when its
Workbook_Activate routine deletes it. I've spent several hours searching
the archives for a solution with no luck.

Any help?

--
David

David wrote

Using XL2K, I have a "New Month" button on the Worksheet Menu Bar
that, when clicked, runs a routine that, among other things, copies
all sheets to a new workbook. Problem is, that button duplicates
(others don't, only this clicked one). It stays there until I
deactivate to book through various means (opening/closing new
workbook, closing/reopening the file), when its Workbook_Activate
routine deletes it. I've spent several hours searching the archives
for a solution with no luck.

Any help?


Never mind.
Found some code using Application.OnTime Now that handled it.
It was a bit cumbersome to watch and wait for the original code to finish,
though, before deleting the extra button.
For MY purposes, since I'm copying all sheets to a new workbook, adding
Application.EnableEvents=False early in the routine eliminated the need for
Application.OnTime Now, and my eyes didn't have to endure as much.

--
David