Consistent Look for Shared Excel Workbook

[rpena4]

I recently created a shared workbook in Excel that will be used by at least 10 team members.
When you open the workbook, the first sheet is a home page with buttons to other sheets.
However, since different users have different Excel settings (i.e. too many toolbars, higher/lower zoom view, etc), everytime a different user opens the app it looks different (buttons are off-screen, they appear too big or too small, etc).

Other than changing everyone's settings individually, is there any way to program it so that the "home page" looks the same on all computers?

 

[SkipVought]

Hi,

You'll need some VBA code. Please post VBA questions in Forum707.

Short answer for a start, might be to macro record maximumizing the window and calling that from the Workbook_Open event.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[rpena4]

Thanks for the advice... just posted in the VBA forum.