Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi every one,
here i am facing a problem that when i am using macro for zoom functionality it is adjusting the sheet to my screen in both vertically & horizontally and objects is getting compressed.
Now what i want is when i click on full screen button the objects should only adjust it's width and dimensions should change.While height of the object should be same.
at time of loading, iam able to see the screen with scroll

after click on "full screen" button

it is adjusting its height also and objects are comprossed.
Please help
thanks in advance
What was the code you written over there? I mean Macro
Sub Autozoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
End Sub
I am not facing any issue on server too along with Reload as well. I don't think what you have done over there.
Because, Since 2 Years i am doing same script to do this. Would you able to share sample to look
please go through the attachment .
on opening the document every thing is fine, but on clik on full screen button objects will compress
Error Facing while opened, Can you reattach for me, Please?
try now
Trust me. This is working for me
I am using this Version?
One more thing, I want to add one point.
Here, You screen resolution should be 1024x768. So then it would work. And one most point here you need to cover up and resize to Single page without Scroll Downs and Sides. Then only This code works.
hi anil,
but i want with Scroll , is there any chance to fix that.
because i want to show all sheets in summary page and details in another page as in table format