LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 206
Default problem removing controls

i have programmatically deleted 'CommandButton2' from my sheet using

ActiveSheet.Shapes("CommandButton2").delete

now when i open my workbook i get the following:

Can't exit design mode because Control 'CommandButton2' can not be created

i can't find any references to command button 2 in my code (on this sheet) -
what do i do? I do have other commandbutton2's on other sheets.

if i try to rename one of my controls to CommandButton2 i get a

Ambiguous name detected: CommandButton2
 
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
Problem with TAB key and Textbox controls Paul M[_4_] Excel Programming 2 June 6th 14 05:54 PM
Problem with looping through userform controls Jeremy Gollehon[_2_] Excel Programming 5 February 17th 05 05:41 PM
problem in removing add-in Bhagwandas Excel Programming 3 November 25th 04 02:22 PM
Removing Controls at RunTime? Neily[_3_] Excel Programming 1 November 25th 04 02:17 PM
A wacky problem - controls move on the screen after printing Ellis Horowitz Excel Programming 2 June 30th 04 10:55 PM


All times are GMT +1. The time now is 08:48 AM.

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"