Hello all,
I have these parameters below that I am trying to apply to a workbook to make it into a clean form view. My issue is that I am trying to apply this view to only this workbook and no other. As soon as I apply the code to run when open, it will also apply it to every workbook I open thereafter until I close it (but not on any file that was currently open). Is there a way to apply this view to only this workbook so other excel files can be opened as normal excel view?
I have these parameters below that I am trying to apply to a workbook to make it into a clean form view. My issue is that I am trying to apply this view to only this workbook and no other. As soon as I apply the code to run when open, it will also apply it to every workbook I open thereafter until I close it (but not on any file that was currently open). Is there a way to apply this view to only this workbook so other excel files can be opened as normal excel view?
VBA Code:
Sub Test12()
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayHeadings = False
Application.DisplayStatusBar = False
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
'With Application
' .WindowState = xlNormal
' .Width = 300
' .Height = 300
'End With
'Sheet1.ScrollArea = "A1:J30"
End Sub