LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default CommandButton - Created using Forms toolbar

ActiveSheet.Buttons.Delete

entered from the immediate window removed
the x^&%&^% button !!

Thanks,

Jim

"Bob Phillips" wrote:

And ... did it?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
Have been googling the last 10 - 15 minutes, but found this one
suggestion..

ActiveSheet.Buttons.Delete

Thought maybe I'd try this statement from the immediate window
to see if it takes care of it..

Thanks again..




"Dave Peterson" wrote:

Sorry, I'm out of guesses.

JMay wrote:

It is not shared and no sheets are currently grouped.
Thank Dave..

"Dave Peterson" wrote:

Is the workbook shared?
Do you have multiple sheets selected/Grouped?

JMay wrote:

Absolutely not a Control Type button...
grrrrr,,,
Thanks Bob

"Bob Phillips" wrote:

Perhaps it is a control toolbox button. Activate the control
toolbox
toolbar, click the design icon (the blue-green triangle), and
then select
the button and see if you can delete it.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JMay" wrote in message
...
This problem has occurred several times to me, but
occasionally I need to Delete such a button and when I
right-click on it NOTHING-Happens. Neither my Worksheet
or Workbook is PROTECTED. How can I delete such a
command-button when right-clicking doesn't bring same
up in edit-mode?





--

Dave Peterson


--

Dave Peterson






 
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
Click event for checkbox from Forms toolbar Carolyn Excel Discussion (Misc queries) 6 September 11th 06 08:16 PM
formatting the list items for ComboBox created using Forms Desmond Excel Discussion (Misc queries) 3 May 4th 06 10:04 AM
How 2 create an Excel Form using & linking items on Forms Toolbar Beanbabeehoohoo Excel Discussion (Misc queries) 1 May 1st 06 06:42 PM
Move or Size Combo Box from forms toolbar With Cells steve-o Excel Discussion (Misc queries) 7 December 6th 05 03:11 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM


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