Adjusting screen layout?

  • Thread starter Thread starter Peter Bernadyne
  • Start date Start date
P

Peter Bernadyne

Hello,

I have a bunch of workbooks with dedicated Add-Ins that I distribute t
users and was wondering if there was a feasible way to force thes
workbooks to appear on users machines exactly the same way as they d
on mine. I am wondering if there is a way to remove users' toolbars
etc. to create the same workspace that would display the workbook
correctly without requiring the user to scroll either horizontally o
vertically (I would want to incorporate something that would put al
the toolbars back exactly as the were upon Workbook_Close, of course).

A kind soul (Don Lloyd) on the programming forum gave me some ver
helpful code on how to use the zoom feature to optimize the view, bu
I'm afraid some of my text might become illegible if this were t
reduce the view to 80% or something.

Any ideas would be gratefully appreciated.

-Pete
 
It is a matter of running code to check which toolbars are being used
plus other settings, at the beginning - storing the information - the
restoring everything at the end
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top