Hello all
I run a sub when with Workbook_Open that goes like this
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
'Application.Run "hideRibbon"
'Application.DisplayFormulaBar = False
'ActiveWindow.DisplayWorkbookTabs = False
'Application.DisplayStatusBar = False
Worksheets("Start Page").Activate
WorkSheets("Start Page").Gridlines = False
I get error 438 : Object doesn't support this property or method on the last line.
The sheet is really called Start Page.
I tried with Activesheet.Gridlines = False and also Thisworkbook.Worksheet("Start Page").Gridlines = False but none of them are working.
What am I doing wrong?
Thank you for your help
I run a sub when with Workbook_Open that goes like this
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
'Application.Run "hideRibbon"
'Application.DisplayFormulaBar = False
'ActiveWindow.DisplayWorkbookTabs = False
'Application.DisplayStatusBar = False
Worksheets("Start Page").Activate
WorkSheets("Start Page").Gridlines = False
I get error 438 : Object doesn't support this property or method on the last line.
The sheet is really called Start Page.
I tried with Activesheet.Gridlines = False and also Thisworkbook.Worksheet("Start Page").Gridlines = False but none of them are working.
What am I doing wrong?
Thank you for your help