Link to home
Start Free TrialLog in
Avatar of Marilync1266
Marilync1266

asked on

Save Macro Shortcut on Desktop - Microsoft Access 2010

I recently upgraded to Office 2010 and I can't figure out how to create on my desktop to point to a macro in a microsoft access database.  Help!

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Create and the macro in the database.
Create a normal shortcut to the database.
Move this shortcut to the desktop.
Edit the properties of the shortcut to include something like this to the end of the text in the "target" box:
/x YourMacro

so the "Target" box might look something like this:

"C:\Documents and Settings\Somebody\My Documents\YourDatabase.mdb" /x YourMacro