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: 2
Default CommandButton

I have a spreadsheet that has a button on it that runs a macro when clicked. I had created a spreadsheet with a generic part and an application specific part (the generic part contains demographic type information). Several people used the sheet successfully, and we have about 30 or so workbooks, with multiple sheets in each, all of which have a working CommandButton1. All execpt 1

On this spreadsheet, I get several different errors depending on what I'm trying to do. The most common one is "Can't exit design mode because CommandButton1 could not be created." So I delete the button and try to recreate it, and it names it CommandButton2. So I change the event handler in VBA, and still get the same message. If there's another button on this sheet hiding some place, I can't find it. Anyone have any ideas?
 
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
Commandbutton David Fixemer Excel Programming 2 February 25th 04 10:18 PM
Macro won't run from CommandButton Nathan Gutman Excel Programming 3 December 24th 03 07:59 PM
CommandButton.Caption Bob Phillips[_5_] Excel Programming 0 September 8th 03 08:15 AM


All times are GMT +1. The time now is 12:02 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"