Ok So I have been putting together a sheet to ensure Overtime is fairly shared out etc.
I've added count cells by colour for calculating day and night shifts worked, and will be adding an OT counter including types of OT done using CountIF,
The stumbling block is setting up the control sheet / filters as the sheet will start 01/0502018 and end 01/04/2019, so I want to filter / hide the column ranges specific to each month, so if you say only need to check July shifts then you only check the July box. but I don't want it to move off the Legend Filter tab (control sheet) when you check the box, it works one way but when unchecking it it brings the Overview sheet to screen, I've attached the sheet and the code is below ! I even tried adding a second sub to ensure I ended up back on the control sheet / filter tab and still doesn't work
Any help is very much appreciated, I know I'm not far off
Sub CheckBox2_Click()
Application.ScreenUpdating = False
Sheets("OVERVIEW").Select
If Range("C:AG").EntireColumn.Hidden = True Then
Range("C:AG").EntireColumn.Hidden = False
Else
Application.ScreenUpdating = False
Range("C:AG").EntireColumn.Hidden = True
Call Tab1
Application.ScreenUpdating = True
End If
End Sub
Sub Tab1()
Application.ScreenUpdating = False
Worksheets(1).Activate
Application.ScreenUpdating = True
End Sub
Display More