Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Screen Size
Is there a way of having the cells you want to see (Width) fit
whatever screen it is connected to? ie: I have a spreadsheet which has many columns but I only want x number showing. If I change the screen size I dont want to resize the column widths to suit the new screen. Is there any code that will do this? Thanks in advance EPJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Screen Size
You can hide the rest of the columns which are not in use
-- If this post helps click Yes --------------- Jacob Skaria " wrote: Is there a way of having the cells you want to see (Width) fit whatever screen it is connected to? ie: I have a spreadsheet which has many columns but I only want x number showing. If I change the screen size I dont want to resize the column widths to suit the new screen. Is there any code that will do this? Thanks in advance EPJ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Screen Size
Hi,
Here is some code I use to ensure that at least Columns up to and including Column P are always visible. It works by using the VisibleRange thingy to manipulate the zoom %. Change the two Columns.Count refs to suit your page. Put this code into an event macro for the sheet you want it to work on. ActiveWindow.Zoom = 100 A = 100 If Windows(1).VisibleRange.Columns.Count < 17 Then Do Until Windows(1).VisibleRange.Columns.Count 16 ActiveWindow.Zoom = A A = A - 1 Loop End If Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Size ? | New Users to Excel | |||
Screen Size Control | Excel Discussion (Misc queries) | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
How Do I Autofit To Screen Size | Excel Worksheet Functions |