Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default How can I remove an unused shortcut label from a Worksheet row?

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,081
Default How can I remove an unused shortcut label from a Worksheet row?

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default How can I remove an unused shortcut label from a Worksheet row


--
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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How can I remove an unused shortcut label from a Worksheet row

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : How to reduce the number of unused worksheet ? Mr. Low Excel Discussion (Misc queries) 5 November 26th 07 07:46 PM
How do i remove unused cells in excel? the_melstar Excel Worksheet Functions 1 March 29th 07 04:14 AM
deleting unused space at the end of a worksheet beckyz Excel Worksheet Functions 3 October 9th 06 08:21 PM
How to remove Keyboard Shortcut CTRL+D csilly1979 Excel Discussion (Misc queries) 3 February 10th 06 09:38 PM
how to remove label formatting (eg label to number) sikkiekaka Excel Worksheet Functions 0 November 4th 04 11:35 PM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"