Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
View set to 'best fit' for User
Hi
Excel 2003. I have a workbook with multiple sheets. Each sheet has multiple tables, two to a printing page. What I would like to do is set the document to open so that the view is exactly a page wide for the User. For example when i set the zoom to 75%, it looks perfect for me but when colleagues use the document, it appears a lot more zoomed in. I have no problems using a macro on opening of the document if needed! Any help, much appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
View set to 'best fit' for User
Hi,
The problem here is that Excel doesn't know the screen resolution so its necessary to call a Window's DLL. John Walkenbach has something on DLL calls in his PowerProgramming book, and maybe on his website? You might explore he http://www.google.com/search?source=...excel&aq=f&oq= -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Adam" wrote: Hi Excel 2003. I have a workbook with multiple sheets. Each sheet has multiple tables, two to a printing page. What I would like to do is set the document to open so that the view is exactly a page wide for the User. For example when i set the zoom to 75%, it looks perfect for me but when colleagues use the document, it appears a lot more zoomed in. I have no problems using a macro on opening of the document if needed! Any help, much appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
View set to 'best fit' for User
You may or may not like the results but put this is the ThisWorkbook module
to do every sheet Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveSheet.UsedRange.Select ActiveWindow.Zoom = True Range("a1").select End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Adam" wrote in message ... Hi Excel 2003. I have a workbook with multiple sheets. Each sheet has multiple tables, two to a printing page. What I would like to do is set the document to open so that the view is exactly a page wide for the User. For example when i set the zoom to 75%, it looks perfect for me but when colleagues use the document, it appears a lot more zoomed in. I have no problems using a macro on opening of the document if needed! Any help, much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing external data 'won't fit' error | Excel Discussion (Misc queries) | |||
User Choosing Which Columns to View | Excel Discussion (Misc queries) | |||
Freeze row height then allow the user to view all with a button | Excel Discussion (Misc queries) | |||
specific user view | Excel Discussion (Misc queries) | |||
How do I write a macro for a button to send user to a custom view? | Excel Discussion (Misc queries) |