View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Code equivalent to Alt + Tab

No apology necessary. I think it just depends on how much "clutter" or extra
stuff you want.



Jimbob wrote:

My very sincere apologies Dave. I didn't mean to disrespect your elegant code
or your efforts on my behalf. It's just that, being an ignorant sort, I
couldn't understand it at first and your shorter option worked first time.
Now that I've studied your first option, I can see it has some robust
features.

Apologies again and, once again, many many thanks for responding.
Regards
Jimbob

"Dave Peterson" wrote:

I don't know. All that malarky did some nice checking.

But glad you have something you can use.

Jimbob wrote:

Bravo Mr P. You are my Number 1 Star.
Thank you so much (and far easier than all that mularky earlier!)

"Dave Peterson" wrote:

Ps. If you just want to cycle through the open windows, you can use a macro
with a line like:

ActiveWindow.ActivateNext

(Slightly less code <vbg)

Dave Peterson wrote:

<<snipped
--

Dave Peterson


--

Dave Peterson


--

Dave Peterson