Standard Worksheet Size

[Sahak]

Hi All,

I have worksheet which designed from columns A to O and my computer’s screen set to 1024 by 768 pixels. When same sheet opens in other computer which has screen settings 1152 by 864 pixels, it shows more columns next to column O which I would not like to be visible. Is there a way or code to make sheet size standard (or something else)?

Thank you in advance

[ilyaskazi]

Why not hide those columns instead ?

Select columns P to IV by pointing your mouse on visible Column names.
Goto Menu: Format -> Column -> Hide


HTH
ilyaskazi.

[Simon Lloyd]

You could try adding this to your Auto_open or workbooks open event Application.WindowState = xlMaximized

Or have a look at this link http://www.vbaexpress.com/kb/getarticle.php?kb_id=337 , it sets your workbook to users resolution!

Regards,
SImon

[Sahak]

Thank you guys very much