Re: Change view without activating sheet?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Peter,

I was afraid that was the response l was going to get.

I have taken your suggestion on board and created loops to set the
work*** views, store in an array, and then restore views
accordingly.

It seems a disproportionate amount of work to simply set the view but
l suppose thats Microsoft / VBA !

Thanks very much for your kind help over the past couple of days.

Regards

Michael

.

Quantcast