Assigning Macro to Menu Option

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to assign the steps Data/Form to a macro but unable to "stop" recording whilst the menu list is displayed. Is it possible to assign such steps?

Cheers!
 
Is it possible to assign such steps?

As I recall (vaguely) it is, but not necessary.

Rightclick your menu bar or any visible toolbar, choose Customize (sic) from
the pop-up. Choose the Commands tab, and the Data category.In the Commands
window, scroll down till you see "Form ...". Click & drag this to your menu
bar. Back in the dialog, click Modify Selection. Edit the Name so it reads
"For&m..." (w/out the quotes). Press Enter.

Close the Customize dialog. Unless you've other custom accelerators, you
should be able to invoke Data -- Form with ALT+M.

(You might like to check out John's Enhanced Data Form -
http://www.j-walk.com/ss/dataform/index.htm)

Rgds,
Andy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create A Button and Assign A Macro To It 2
Assign Macro to a Cell 2
Macro code behind button 1
Sharing Macros 1
Comment with date stamp, again 1
How to Create a Macro to Import External Data 0
Assigning Macros 4
Assigning macro to toolbar - only works sometimes! 4

Back
Top