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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com