prevent button from copying
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
|