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,

Turn on your macro recorder and record all the things that you do to put the controls back into place.

Post your recorded code for help customizing your process.

Skip,

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

 

[rpena4]

I'm not sure what you mean by "put controls back into place."

Besides, I don't think I need help customizing the process... just how it looks on everyone's screen(s).

 

[SkipVought]

"I'm not sure what you mean by 'put controls back into place.'"

"looks different (buttons are off-screen, they appear too big or too small, etc). "

Just trying to answer your original question.

Skip,

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

 

[rpena4]

OK... I think I see what you were saying now.

I don't actually do anything to put the controls back into place because they don't move.
There is absolutely no fundamental change to the actual workbook.
The problem is just the way it appears on the particular user's screen.

So, as a solution, what I'm looking for is a consistent look (i.e. all controls centered in one view), regardless of the end user's display settings and Excel view. For example, Google's home page looks the same on pretty much every computer no matter what the settings are.

Sorry for the long post, but this is something I've been researching for awhile with no success so far.

 

[PHV]

Why not using an UserForm ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

"Besides, I don't think I need help customizing the process... just how it looks on everyone's screen(s)."

That IS customizing the process.

Short of recreating the buttons on a UserForm as PHV has suggested, you must CODE the repositioning of each control to conform to the available size and postition of the user's workbook when it is opened.

Hence, the macro recording exersize, for your convenience and enlightenment.

Skip,

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

 

[rpena4]

I think I'll try the UserForm option... thanks again for the help.