Hello,

I have designed several dedicated excel workbooks for use with specifi
Add-Ins I have assembled. On distributing these to users, I have com
across the somewhat vexing problem that everyone's excel layout i
different, which causes variations in what important features of
worksheet are visible and which are obscured, etc.

Obviously, I have designed the workbooks using my own settings and in
way that makes everything legible without requiring the user to scrol
(either horizontally or vertically) - making my workbooks appear almos
like self-contained applications. Ideally I would want these to appea
on everyone's machine just the way they do on mine.

Perhaps some of this depends on monitor size and display settings, bu
does anyone know if there is some simple code I could include in m
distributed workbooks that would standardize the way users view the
(like standardizing the view size to 100%, removing extra toolbars lik
drawing/reviewing, etc.) and then have all these put back into plac
exactly as they were once the user closes out the workbooks?

Thanks in advance to any help anyone can give.

-Pete

--
Message posted from http://www.ExcelForum.com