is it possible to toggle display of project window with control-R

  • Thread starter Thread starter Brian Murphy
  • Start date Start date
B

Brian Murphy

Dear Chip and Zack,

I posted a reply yesterday using the google news interface, but it never
showed up??? Today the google interface seems to be seriously
disfunctional, so I'm using outlook express this time.

Anyway, I tried the macro you suggested and it works just like you said.
But I can't figure out how to assign it to a key that works in the VBA IDE.
Can you point me to an example that shows how to do this? I tried OnKey,
but that didn't seem to work in the IDE.

Thanks,

Brian
 
Unfortunately, you can't assign keys in the VBE.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
That Bullen chap is something else!

This is great. I now have "^R" working like a charm to toggle the
Project Window in Excel 2003.
I also have "^G" working as a toggle for the Immediate window.

There seems to be some peculiarities regarding focus depending on
whether those windows are docked or undocked, but it still works.

Many thanks,

Brian
 
Back
Top