Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Crap,,,
How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Sorry, I failed to mention that the button
was created using the Forms toolbar, NOT the Control Toolbox. I have 3 buttons and I only want to delete 1 of the 3. Tks In Advance "Jim May" wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Click View/Toolsbars and select Visual Basic Toolbar and then go to
design mode .Once you are in design mode just select the command button you wish to delete and then press delete. Jim May wrote: Sorry, I failed to mention that the button was created using the Forms toolbar, NOT the Control Toolbox. I have 3 buttons and I only want to delete 1 of the 3. Tks In Advance "Jim May" wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Is your worksheet protected?
Do you have multiple worksheets grouped? Is the workbook shared? Jim May wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
No,
No, and No, Thanks, Jim "Dave Peterson" wrote: Is your worksheet protected? Do you have multiple worksheets grouped? Is the workbook shared? Jim May wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Your recommendation only works if I created the button using the Control
Toolbox; RIGHT??? I used the Forms Menu resulting toolbar. Jim "ST" wrote: Click View/Toolsbars and select Visual Basic Toolbar and then go to design mode .Once you are in design mode just select the command button you wish to delete and then press delete. Jim May wrote: Sorry, I failed to mention that the button was created using the Forms toolbar, NOT the Control Toolbox. I have 3 buttons and I only want to delete 1 of the 3. Tks In Advance "Jim May" wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
I don't have any other guesses.
Jim May wrote: No, No, and No, Thanks, Jim "Dave Peterson" wrote: Is your worksheet protected? Do you have multiple worksheets grouped? Is the workbook shared? Jim May wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Forms CommandButton on Worksheet
Thanks Dave for looking at my problem;
If/when I solve I'll let you know the problem. Jim "Dave Peterson" wrote: I don't have any other guesses. Jim May wrote: No, No, and No, Thanks, Jim "Dave Peterson" wrote: Is your worksheet protected? Do you have multiple worksheets grouped? Is the workbook shared? Jim May wrote: Crap,,, How do I delete a command button I've entered on my Worksheet right-clicking does nothing; control-key+right-click does nothing alt+ctl+right-clicking does nothing What's the secret? TIA, Jim -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find and delete duplicates in excel worksheet? | Excel Discussion (Misc queries) | |||
How do I delete or remove additional blank pages of a worksheet? | Excel Worksheet Functions | |||
how to delete an excel file? how to e-mail a worksheet? | New Users to Excel | |||
How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions | |||
how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) |