View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 195
Default 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