Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom EXCEL chart value axis BRAIN TEASER | Charts and Charting in Excel | |||
View Custom View with Sheet Protection | New Users to Excel | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
Custom View Bug? | Excel Discussion (Misc queries) |