Size of the objects as per screen size

[#1]

Hello,

Can we manage the size of the objects as per screen size?

[#2]

Hi All,

I did try to call the below macro on button click but it is not working

Sub Autozoom

    ActiveDocument.GetApplication.WaitForIdle

    ActiveDocument.ActiveSheet.FitZoomToWindow

    ActiveDocument.GetApplication.WaitForIdle

    ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

End Sub

Please can anyone tell why it is not working?

[#3]

Macros do not work on accesspoint?

If yes what is the work around or alternative to it?