open or close subdatasheet with keystrokes

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

Guest

Are there keystroke commands that can open or close a subdatasheet? I have
some users who would like to avoid using a mouse-click to achieve this.
Any input is greatly appreciated!
 
Create a macro, name it AutoKeys, check help about these macro.
You can specify in this macro a short cut key for these operations.
 
I have little experience with macros. It seems liske I should use the
"SendKeys" action, but beyond that I'm at a loss, even with the help topics.
Can you offer any more specific instructions, or a place where I can
reference more details about this?
Thanks again!
 
I'll try to give an example, and you can continue from there

Create a new macro
In the menu bar select > View > Macro Name
In the Macro Name type {F4}
In the Action select MsgBox
In the msg on the button type any thing you want
Save the macro and name it AutoKeys
Close it, and press F4 , you should get the message.

Now, all you need to do is select the key, and then the action for this key
 

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

Back
Top