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

[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

 

[Chip Pearson]

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)

 

[Tom Ogilvy]

Stephen Bullen show's how you might simulate this capability:

http://www.oaltd.co.uk/Excel/Default.htm

scroll about 2/3rds of the way down the page

look for the entry for VBEOnKey.zip

or directly http://www.oaltd.co.uk/DLCount/DLCount.asp?file=VBEOnKey.zip

 

[bmurphy]

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