LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom EXCEL chart value axis BRAIN TEASER MikeM_work Charts and Charting in Excel 1 September 8th 08 06:49 PM
View Custom View with Sheet Protection John H[_2_] New Users to Excel 1 February 16th 07 05:54 PM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM
Missing "Custom View" entry from View menu mycroft777 Excel Discussion (Misc queries) 1 February 3rd 06 05:33 PM
Custom View Bug? [email protected] Excel Discussion (Misc queries) 7 November 15th 05 07:45 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"