View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Linking a Ribbon control with an help file

One work-around that you might be interested in is to test the state of
SHIFT key when the button is clicked. In the code assigned to that control
you could use

Sub Whatever()
If IsShiftKeyDown = True Then
''''''''''''''''''''''''''''''''''
' display help
''''''''''''''''''''''''''''''''''
Exit Sub
End If
''''''''''''''''''''''''''''''''''
' normal macro behavior
''''''''''''''''''''''''''''''''''
End Sub

See http://www.cpearson.com/excel/KeyTest.aspx for info about how to test
the state of the SHIFT key. It isn't as nice as a simple F1, but may be
satisfactory.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Ahasverus" wrote in message
...

Thanks for the answer, Jim.

Obviously, there are much improvements to do with the new interface.

Jim Rech a écrit :
As far as I know it is not possible because we have no way to know which
control the cursor is hovering over when F1 is pressed.