Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shared file want same view
I want everyone who uses the shared file to have the same view. I see under
custom views all the personal views listed. Do I just delete them, or will they be re-created as each person saves the workbook. The problem comes when someone updates the file and puts in the new worksheets we want everyone to view them at 75% and there are several other settings. Sherry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
shared file want same view
Put the settings you want them to start off with in the workbook's _Open()
event handler: Private Sub Workbook_Open() ActiveWindow.Zoom = 75 End Sub would set the view to 75%. If you are unsure of how to code up instructions for setting all of the things needed to insure that people at least initially view the workbook as you intend it to be viewed, record a macro that sets things up exactly the way you want and copy the code it creates into the _Open() event routine. If you're unsure of how to put code into the Workbook's events, here's a page with instructions, with screen shots, to assist. It's actually one of those things that it takes longer to tell how to do than to actually do it. http://www.jlathamsite.com/Teach/WorkbookCode.htm "shertone" wrote: I want everyone who uses the shared file to have the same view. I see under custom views all the personal views listed. Do I just delete them, or will they be re-created as each person saves the workbook. The problem comes when someone updates the file and puts in the new worksheets we want everyone to view them at 75% and there are several other settings. Sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula calculation in a Shared Excel File | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
shared file | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |