How to Create Shortcut

[mks123]

Hi Frndz,

Could anyone help me with this line of code..trying to figure out how this macro works.

Ref site :https://msdn.microsoft.com/en-us/lib.../ff194247.aspx

Sub CreateSimpleShortcutMenu()
Dim cmbShortcutMenu As Office.CommandBar


' Create a shortcut menu named "SimpleShortcutMenu.
Set cmbShortcutMenu = CommandBars.Add("FirlstdShortcutMenu", msoBarPopup, False, True)


' Add the Remove Filter/Sort command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=605


' Add the Filter By Selection command.
cmbShortcutMenu.Controls.Add Type:=msoControlButton, ID:=640


Set cmbShortcutMenu = Nothing


End Sub

Regards,


Mukesh Y

[aytee111]

What is your issue?

[CJ_London]

do you mean a shortcut menu (which is what your code is about) or do you mean a shortcut to a file, for example on your desktop?

[mks123]

thanks for reply guys....

I just wanted to how can I use this code/ what is the use of this code.
I have read that this create shortcut somewhere but never figure out.

[CJ_London]

the code you provided is documented, so you can see what it does. The link you provided suggests where to put the code and how to use it - what else do you want to know?

[mks123]

I'm able to run this code but don't know where it get save ... link display this info "Once you've run the code, the shortcut menu is saved as part of the database. You don't have to run the same code to re-create the shortcut menu every time that you open the database."

[CJ_London]

the link is telling you only need to run it once, not every time you open the database - the database you have run it in will have been updated for all time. If you create a new database, you will need to run the code again in the new database if you want use the same functionality in the new database.

[ssanfu]

You have to read the next paragraph:

To assign the shortcut menu to a form, form control, or report,
set the Shortcut Menu property of the object to Yes and
set the Shortcut Menu Bar property of the object to the name of the shortcut menu.
For this example, set the Shortcut Menu Bar property to SimpleShortcutMenu.

[mks123]

thanks guys!!

[Micron]

I just wanted to how can I use this code/ what is the use of this code.
I have read that this create shortcut somewhere but never figure out.

This is not a shortcut to anything. This is a shortcut menu, AKA context menu - like the ones you open when you right click on something.