View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
rwebster3 rwebster3 is offline
external usenet poster
 
Posts: 2
Default CommandButton

Chris

I tried renaming the button and got the error you said I would get. At this point I took the long way around. I had noticed that the button name was still in the Object Box of the VB edit window, even though the button and code were removed. I then made a copy of the sheet. On the copied sheet, the button declaration was gone. I then deleted the old sheet completely, renamed the new sheet, and created the button from scratch. Works great now

But, I'd still like to have the code that locates and deletes stuff like this. It could come in handy in the future

Thanks

Rick W.