Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default CommandButton

try this for now. go ahead and delete the 1st button and rename CommandButton2 to CommandButton1 using the properties window( Name not Caption!)
if you get an ambiguous name error respond back and i'll give you some code to locate and delete the CommandButton1
  #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.
Reply
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 10:30 AM.

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

About Us

"It's about Microsoft Excel"