VBA to hide hide specific columns on more than one worksheet
I am currently using this code below to hide columns H and M on the Cartoworkflow sheet. I would also like to hide column G on a worksheet called "NEW_Procedures" located in the same workbook. I tried to just add a line in the code below, but am getting an error message.
Private Sub Workbook_Open()
Sheets("Cartoworkflow").Columns("h:h").ColumnWidth = 0
Sheets("Cartoworkflow").Columns("m:m").ColumnWidth = 0
If WorksheetFunction.CountA(Sheet8.Cells) = 0 Then