Excel resize on open

[timotai]

Hi all

is there a way I can make an excel spreadsheet resize to fit the screen resolution on the PCit is being opened on. This is because the users who will pick up this spreadsheet have varying resolutions.

Thanks

Tim

 

[Zygor]

Have you tried

Private Sub Workbook_Open()
ActiveWindow.WindowState = xlMaximized
End Sub

 

[timotai]

I think there is a bit of confusion with what I want. it is the zoom on the worksheet that I want to change. I want it to adjust to fit all of my data on my spreadsheet into the screen so the user does not have to scroll to see any of it.

Thanks

Tim

 

[timotai]

You got me onto the right track though so thanks. I have found my solution :


ActiveWindow.Zoom = False


Now my other question is it possible to run this at start up like an autoexec?

Thanks

tim

 

[Loomah]

Tim
Add your code to the workbook open event as Zygor did.

If you don't know about events you could have a look at SkipVought's FAQ - faq707-1945

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​