I have a task pane that can be invoked (i.e. set to appear) when I first hit alt Y on the keyboard and then Y1 as a second keyboard combination and then if I repeat the two keyboard sequences it will hide the task pane.
Is it possible to somehow assign these keyboard combinations to an Active X or a Form Command button so that the user can simply click on the button to show the task pane and then click it again to close it.
I would also want the text on the button to change accordingly, from Show to Hide to Show again at the same time.
I would be grateful for any help as to how to accomplish this, if it is even possible to do.
This button would appear on the worksheet and not on a UserForm.
Many thanks...
Bookmarks