Excel - Fixed Window Size 1

[cwsstins]

Is it possible to create a setting in Excel that will force the file to open with a standard, fixed window size, regardless of how the file would normally open on various PCs?

Thanks,
stinsman

 

[KenWright]

The workbook:- Try setting the size you want it to be, then Tools / Protection / protect workbook / protect windows & structure

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[cwsstins]

Thanks Ken...that definitely works for the workbook...the only problem is the application itself still opens in whatever size was last used, with a fixed workbook window within. I suppose I can work with that, but I was hoping to find a way to fix the actual application window as well. Any suggestions?

Thanks,
stinsman

 

[KenWright]

Private Sub Workbook_Open()
    With Application
        .WindowState = xlNormal
        .Width = 400
        .Height = 500
    End With
End Sub

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[cwsstins]

That did the trick. Thanks Ken!

stinsman

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------