need open view size to be standard regardless of computer opening sheet

[davehnj]

I need to distribute a workbook companywide but would like the default view to be the same throughout. How does one accomplish this?

 

[mikerickson]

You could use Custom Views, but that might not effect the size of Excel's window within the screen.

 

[davehnj]

Thanks for your amazingly quick response but I believe this would only change the view on my computer, not everyone to whom this workbook would be distributed.

 

[mikerickson]

CustomViews is a property of a WorkBook object. They travel with the workbook.

 

[davehnj]

How does one implement "custom views"?

 

[mikerickson]

To set the CustomView, arrange the screen the way you want it and use CustomView from the View Tab (or CustomView from the View menu, depending on which version of Excel you are on.)

To have that view set, code like this could be put in the workbook's Open event. After that the user is in control.

ThisWorkbook.CustomViews("test").Show

 

[davehnj]

Thank you so much. I really appreciate this.