LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CommandButton as array ? apis Excel Discussion (Misc queries) 2 November 17th 11 05:36 PM
Hyperlink using commandbutton? Bob Excel Discussion (Misc queries) 2 May 29th 09 12:54 PM
Floating a CommandButton Ayo Excel Discussion (Misc queries) 2 June 2nd 08 08:08 PM
CommandButton rwebster3 Excel Programming 0 April 14th 04 08:16 PM
Commandbutton David Fixemer Excel Programming 2 February 25th 04 10:18 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"