Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I put a macro shortcut on Row 1 of a worksheet using Forms controls. Now I
no longer need this shortcut; I've deleted the associated macro and am now left only with a labelled box which I cannot remove using the Help suggestions. -- tanda |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
You should be able to delete it.
Press the F5 key, click on Special, select Objects click on OK It should now be selected - press the Delete key to get rid of it. "tanda" wrote: I put a macro shortcut on Row 1 of a worksheet using Forms controls. Now I no longer need this shortcut; I've deleted the associated macro and am now left only with a labelled box which I cannot remove using the Help suggestions. -- tanda |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() -- tandangbata "Duke Carey" wrote: You should be able to delete it. Press the F5 key, click on Special, Sorry, didn't work. When I clicked special, then Objects, I get: "No objects found". When I clicked the shortcut box, then the F5 key, nothing happens. select Objects click on OK It should now be selected - press the Delete key to get rid of it. "tanda" wrote: I put a macro shortcut on Row 1 of a worksheet using Forms controls. Now I no longer need this shortcut; I've deleted the associated macro and am now left only with a labelled box which I cannot remove using the Help suggestions. -- tanda |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
tanda
Perhaps you used a button from the Control Toolbox. You must be in "design mode" in order to find that button for deletion. ToolsCustomizeControl Toolbox. Select the design mode Icon........top left of Control Box.....has a picture of some drafting tools. Now try the F5Special. Gord Dibben MS Excel MVP On Wed, 23 May 2007 11:37:04 -0700, tanda wrote: Sorry, didn't work. When I clicked special, then Objects, I get: "No objects found". When I clicked the shortcut box, then the F5 key, nothing happens. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 : How to reduce the number of unused worksheet ? | Excel Discussion (Misc queries) | |||
How do i remove unused cells in excel? | Excel Worksheet Functions | |||
deleting unused space at the end of a worksheet | Excel Worksheet Functions | |||
How to remove Keyboard Shortcut CTRL+D | Excel Discussion (Misc queries) | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |