hi,
i am using the following script on 'this workbook' so when the file opens, the first sheet is full screen and stretched from a1 to U1 (this is the DefinedRange). i would like all sheets to be stretched from A1 to U1. what would b the code for this.
thank you
i am using the following script on 'this workbook' so when the file opens, the first sheet is full screen and stretched from a1 to U1 (this is the DefinedRange). i would like all sheets to be stretched from A1 to U1. what would b the code for this.
thank you
VBA Code:
Private Sub Workbook_Open()
Application.DisplayFullScreen = True
Range("DefinedRange").Select
ActiveWindow.Zoom = True
'Cells(1, 1).Select
End Sub