VBA view adjusting for screen resolution

  • Thread starter Thread starter Big Chris
  • Start date Start date
B

Big Chris

Hi,

Please can you help with this problem...?

I have a recorded macro which runs and optimises the view by selecting
an area across the top of each sheet and selecting 'View', 'Zoom' and
then 'Fit selection'. the idea is that the worksheet details won't
overspill the page, but will always fir perfectly no matter if viewed
at 800x600 or 1024x768 or anyother for that matter.
It works fine with 1024x768 but still overflows the screen at 800x600.
This doesn't seem logical as all the macro is doing is performing a
very logical set of instructions.

Can anyone advise me please?

Thanks,
 
Chris,

You could try setting the zoom to a specific number of columns.
Personally, I don't like it as it shrinks the font (especially on
any controls that are on the sheet), but you can try it.

ActiveWindow.Zoom = False
Range("A1:D1").Select
ActiveWindow.Zoom = True

John
 
Back
Top