open or close subdatasheet with keystrokes

K

Kevin

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!
 
O

Ofer

Create a macro, name it AutoKeys, check help about these macro.
You can specify in this macro a short cut key for these operations.
 
K

Kevin

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!
 
O

Ofer

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
 
Top