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
|