Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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
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
Formula calculation in a Shared Excel File Cillian Excel Discussion (Misc queries) 0 December 1st 05 06:22 PM
Links picking up values from an older version of linked file Cate Links and Linking in Excel 4 October 20th 05 01:53 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 0 March 19th 05 06:01 PM
shared file tjh Excel Worksheet Functions 0 March 10th 05 04:33 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 01:02 AM.

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

About Us

"It's about Microsoft Excel"