800x600 change to 1074x768

[pichai]

Hi, My excel file setup form my computer 1074x768 pixels .
when other user used my file in her computer with setting up 800x600 pixels
it showed the difference view size .not so good.
Can do anything by vba code in myfile ?, when user open the file ,it setting up automatic with the 1074x768 pixels , for a good view. and then after she closed the file .her computer doing with the same as her setting 800x600 as before she open the file.

[VBA Noob]

Just a warning

Messing with screen size may annouy users if they are switching between excel and another app.

If you stilll need to then take a look at links

http://www.vbaexpress.com/kb/getarticle.php?kb_id=337

http://www.j-walk.com/ss/excel/tips/tip06.htm

VBA Noob

[pichai]

Thank for your detail