How can I remove an unused shortcut label from a Worksheet row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
--
tandangbata


Duke Carey said:
You should be able to delete it.
Press the F5 key,
click on Special,
Click to expand...


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.
 
tanda

Perhaps you used a button from the Control Toolbox.

You must be in "design mode" in order to find that button for deletion.

Tools>Customize>Control Toolbox.

Select the design mode Icon........top left of Control Box.....has a picture of
some drafting tools.

Now try the F5>Special.


Gord Dibben MS Excel MVP
 
Back
Top