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)

"Brian Murphy" wrote in message
...
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

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/DLCou...e=VBEOnKey.zip

--
regards,
Tom Ogilvy


"Chip Pearson" wrote in message
...
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)

"Brian Murphy" wrote in message
...
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

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



On Jan 30, 8:45 pm, "Tom Ogilvy" wrote:
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 directlyhttp://www.oaltd.co.uk/DLCount/DLCount.asp?file=VBEOnKey.zip

--
regards,
Tom Ogilvy

"Chip Pearson" wrote in message

...

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)

"Brian Murphy" wrote in message
...
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