Hi,

Just wondering how you can assign a shortcut to a form in Excel?

i.e.the only way to open "frmApprove" is if you hit "ctrl+g+v"

Any ideas?

Thanks!

Sub Open_FrmApprove
frmApprove.Show
End Sub

(in a normal module)

Tools=>Macros=>Macro=> pick up Open_FrmApprove, Options, assign shortcut keys.

e.g. Ctrl+g

Martin

One moment... did you say, 'the only way'?

Like for instance that not even frmApprove.Show from VBA intermediate window works?