Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen Size Control
Hi
When I activate page 2 I want the screen to becaome larger. That is the problem. By hiding sheet tabs and navigating to sheets with macros it is possible. However the user can unhide sheet tabs. could any one assist? Regards M Varnendra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen Size Control
Hi
On sheet2, paste the following 2 macros onto the Sheet code Private Sub Worksheet_Activate() ActiveWindow.Zoom = 200 End Sub Private Sub Worksheet_Deactivate() ActiveWindow.Zoom = 100 End Sub Set the Zoom levels to whatever you wish. To carry out the task, Copy the 2 macrosRight click on tab for Sheet2View codePaste in large white panel to right of screen. -- Regards Roger Govier "Varne" wrote in message ... Hi When I activate page 2 I want the screen to becaome larger. That is the problem. By hiding sheet tabs and navigating to sheets with macros it is possible. However the user can unhide sheet tabs. could any one assist? Regards M Varnendra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Screen Size Control
Hi Roger
That works. Thank You. Regards M Varnendra "Roger Govier" wrote: Hi On sheet2, paste the following 2 macros onto the Sheet code Private Sub Worksheet_Activate() ActiveWindow.Zoom = 200 End Sub Private Sub Worksheet_Deactivate() ActiveWindow.Zoom = 100 End Sub Set the Zoom levels to whatever you wish. To carry out the task, Copy the 2 macrosRight click on tab for Sheet2View codePaste in large white panel to right of screen. -- Regards Roger Govier "Varne" wrote in message ... Hi When I activate page 2 I want the screen to becaome larger. That is the problem. By hiding sheet tabs and navigating to sheets with macros it is possible. However the user can unhide sheet tabs. could any one assist? Regards M Varnendra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
Font size on the screen is different when printed | Excel Discussion (Misc queries) | |||
Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
How can I control the full screen display width ? | Excel Discussion (Misc queries) | |||
How Do I Autofit To Screen Size | Excel Worksheet Functions |