Results 1 to 5 of 5

Thread: shortcut key to list of macros

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    shortcut key to list of macros

    Is there a shorcut that brings up the list of available macros --- I dont want the user to have the developers tab turned on

    Thanks in advance Rasm
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by Rasm View Post
    Is there a shorcut that brings up the list of available macros --- I dont want the user to have the developers tab turned on
    Do you mean you want to display the dialog box that let's you run a macro when on a worksheet? If so... ALT+F8 and, if not, I think you might need to expand your description somewhat.

  3. #3
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14
    Rick ---- ALT+F8 is exactly what I was looking for --- thanks Rasm
    xl2007 - Windows 7
    xl hates the 255 number

  4. #4
    Member mrmmickle1's Avatar
    Join Date
    Sep 2012
    Posts
    51
    Rep Power
    13
    Rasm,

    As you continue to expand the quantity of macros that you use at some point this may become helpful. It is a macro that can be used as a shortcut to other macros. You can Customize your ribbon and put this macro on the ribbon or you can use a shortcut key for this particular macro that will give you access to other frequently used macros:

    Code:
    Sub MacroShortcutList()
    'Standard Module code!
    'Display pick list box.
    Dim Message, Title, Default, MyPick
    'Set prompt."
    'Add other macros to list with & Chr(13) & "Macro Name"
    Message = "Select the number of the macro you want to run:" & Chr(13) & _
    "1.  Select No Macro" & Chr(13) & "2.  Delete Rows Based On Criteria" _
    & Chr(13) & "3.  Freeze Top Row"
    'Set title.
    Title = "Select Macro!"
    'Set default.
    Default = "1"
    
    'Display message, title, and default value.
    MyPick = InputBox(Message, Title, Default)
    'Optional, control box position!
    'Display dialog box at position 100, 100.
    'MyPick = InputBox(Message, Title, Default, 100, 100)
    
    Select Case MyPick
    
    Case 1
    MsgBox "No Macro Selected!"
    
    'Add additional Case code as needed!
    Case 2
    Call DeleteRowsCriteria
    
    Case 3
    Call FreezeTopRow
    
    Case Else
    Exit Sub
    
    End Select
    End Sub
    Change the Case to call your own macros. The Message = portion is just text that is used in the message box. Chr(13) is equivalent to the enter key.

  5. #5
    Junior Member
    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    Smile

    Hi,
    Thanks for your information. I too was searching for this type of shortcut. I Have found more short cuts for power point when searching on Google.
    It is PowerPoint ShortcutTools 2.0 .

Similar Threads

  1. Replies: 2
    Last Post: 05-13-2013, 12:03 AM
  2. Replies: 1
    Last Post: 03-30-2013, 11:48 PM
  3. Add Macros To Custom Menu
    By mfaisalrazzak in forum Excel Ribbon and Add-Ins
    Replies: 2
    Last Post: 03-01-2013, 04:23 PM
  4. $60 Macros To Do Data Structure
    By obed_cruz in forum Hire A Developer
    Replies: 14
    Last Post: 04-11-2012, 10:08 AM
  5. How To Use getKeytip to Assign the Key Tip of a Ribbon Tab
    By Excel Fox in forum Excel Ribbon and Add-Ins
    Replies: 0
    Last Post: 04-19-2011, 11:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •