Web publishing resolution change???

[tj32]

hi

I am saving my workbook as a web page using the following code:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\test.htm", FileFormat:=xlHtml, _
ReadOnlyRecommended:=False, CreateBackup:=False

and this works fine but when I view the web page it is just too big for the screen and I have to keep scrolling - very annoying. I do not want to change my windows resolution.

Is there an alternative/addition bit of vba code to resolve this?

Cheers

TJ

[Leith Ross]

Hello tj32,

Welcome to the Forum!

Try changing the Zoom property of the ActiveWindow. This examples reduces the display to 80% of the original size.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[shg]

Cross-post: http://www.ozgrid.com/forum/showthread.php?t=83578

[tj32]

This just changes the excel window not the html window?

Any ideas?