Design!

[#1]

Hello everyone.

I need some help again.

I'm in the process o creating an image to use it as background of my application, the resolution of my laptop monitor is 1366 x 768 and i want to know if there is a way to fit my application to different monitor resolutions in an automatic way, i mean when i open my app in another computer with more or less resolution i want that it fits the screen...

Is there a way to do that??

Thanks...

Regards!

[rajeshvaswani77]

You need to add a button called fit to window. To the button add a trigger that runs a macro. Use below code in the macro.

Sub Zoom

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

if sp.ZoomFactor=1 then

ActiveDocument.ActiveSheet.FitZoomToWindow

ActiveDocument.GetApplication.WaitforIdle

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

else

sp.ZoomFactor = 1

mysheet.SetProperties sp

end if

End Sub

[#3]

Thank's a lot... i'll try this right now!!