Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
Several times I've created a command button (from the
Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
Make sure the worksheet is unprotected.
And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
To insure that a Worksheet is Not Protected -- Do you
Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
I glance at the toolbar--when the worksheet is protected lots and lots of icons
are greyed out. But, yep, going through the menu system should work. Did you try the control toolbox stuff? JMay wrote: To insure that a Worksheet is Not Protected -- Do you Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
I'm 99% sure it is NOT protected; but I'll check it Monday (it's at
work). " wrote in message : I glance at the toolbar--when the worksheet is protected lots and lots of icons are greyed out. But, yep, going through the menu system should work. Did you try the control toolbox stuff? JMay wrote: To insure that a Worksheet is Not Protected -- Do you Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
Don't forget to try the control toolbox stuff.
JMay wrote: I'm 99% sure it is NOT protected; but I'll check it Monday (it's at work). " wrote in message : I glance at the toolbar--when the worksheet is protected lots and lots of icons are greyed out. But, yep, going through the menu system should work. Did you try the control toolbox stuff? JMay wrote: To insure that a Worksheet is Not Protected -- Do you Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
i find right click and CUT does the trick.....
-- paul remove nospam for email addy! "unknown" wrote: |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
Have you tried
Tools Options View tab under the "Objects" section, selecting "show all" Dave Peterson wrote: Don't forget to try the control toolbox stuff. JMay wrote: I'm 99% sure it is NOT protected; but I'll check it Monday (it's at work). " wrote in message : I glance at the toolbar--when the worksheet is protected lots and lots of icons are greyed out. But, yep, going through the menu system should work. Did you try the control toolbox stuff? JMay wrote: To insure that a Worksheet is Not Protected -- Do you Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forms Command Button - Removal
I had the same problem. Once I showed the control toolbox toolbar, I was
able to delete the command button. Thanks. "Dave Peterson" wrote: I glance at the toolbar--when the worksheet is protected lots and lots of icons are greyed out. But, yep, going through the menu system should work. Did you try the control toolbox stuff? JMay wrote: To insure that a Worksheet is Not Protected -- Do you Do so by going to the Menu, Tools, Protection ,, and if you See "Protect Sheet..." and "Protect Workbook..." -- then Neither are protected, RIGHT? Contra if you see "Unprotect Sheet..." and or "Unprotect Workbook..." Then THEY ARE PROTECTED.. RIGHT? TIA, Jim " wrote in message : Make sure the worksheet is unprotected. And if by chance, you meant a commandbutton from the Control toolbox toolbar (not a button from the Forms toolbar), show that control toolbox toolbar and click on the design mode icon. Delete the commandbutton and click the design mode button once more. JMay wrote: Several times I've created a command button (from the Forms Toolbar) to run a given Macro. Later I realize I wish to delete the macro AND the Command button. NONE of my workbboks or worksheets are PROTECTED. When I right-click on the button hoping it will come Up in edit mode for me to delete - but nothing happens. Any suggestions (on how to delete an unwanted button)? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing forms | New Users to Excel | |||
Component not correctly registered Error opening Forms in Excel | Excel Discussion (Misc queries) | |||
Print out certain forms automatically | Excel Discussion (Misc queries) | |||
Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
how do I combine two forms with different size columns to make on. | Excel Discussion (Misc queries) |