LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default shortcut key not not running macro's all of a sudden

I have a macro that I have been using just fine then
yesterday I was using it a few times and then it died.

I hit cntrl+x to run the following macro but now it wont
work.

Sub gotoselection()
x = Cells.Find(InputBox("Enter number to find")).Address
Application.Goto reference:=Range(x).Offset(, -4)
End Sub

Is there a way to view all the cntrol key assignments

Is there a way to clean out all the old key assignements -
as i suspect I may have used the same cntrl +something
sequence on more then one macro.

The reesult is that cntrl + x may be assigned to more then
one macro. The thing is I can't find the macro or the work
book where it's hiding.

Thanks Todd
Thanks
 
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
running macro's in Excel 2007 Texas Tonie[_2_] Excel Worksheet Functions 0 May 4th 09 07:07 PM
Shortcut key not running macro properly Ted M H Excel Discussion (Misc queries) 5 October 1st 08 11:07 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Running XY chart labeller using a macro's parameters and arguments. Hari Prasadh Charts and Charting in Excel 1 July 12th 05 05:00 PM
Running a macro from a desktop icon shortcut Sofia Excel Programming 2 July 15th 03 08:01 PM


All times are GMT +1. The time now is 08:20 PM.

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

About Us

"It's about Microsoft Excel"