Custom View - TEASER
 

Can anyone help?

I need code to put in the Worksheet_Activate event procedure
Range "A1:M30" contains various controls.
I'd like it so that whenever anyone activates this sheet they can see
all the controls in "A1:M30"(PROBLEM IS THAT DIFFERENT PEOPLE HAVE
DIFFERENT NUMBERS OF TOOLBARS IN USE)
Probably 2 approaches:

1.Strip out all toolbars apart from the main one, only problem with
this is I don't know how to get things back to how the user had then
configured before they activated the sheet!

2.Somehow find the size of the users screen and make the range
"A1:M30" fit to that.

Any help greatly appreciated
Jason

Custom View - TEASER
 

Here's how to do the second option:

Range("A1:M30").Select
ActiveWindow.Zoom = True
Range("A1").Select

The first option can be done (you just need to save what toolbars wer
up on another sheet and put them back before the workbook closes).
I've tried this before, and depending on how the user uses excel the
may not like it...



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26545

Custom View - TEASER
 

Cheers matey - as simple as that hey!..great stuff!
Might avoid the other option for the time being as it might upset some
users if anything goes wrong and they are left having to sort out
their toolbars from a fresh!

kkknie wrote in message ...
Here's how to do the second option:

Range("A1:M30").Select
ActiveWindow.Zoom = True
Range("A1").Select

The first option can be done (you just need to save what toolbars were
up on another sheet and put them back before the workbook closes).
I've tried this before, and depending on how the user uses excel they
may not like it...

K