Solocharles
New Member
Hi, attached file macro is working in Microsoft but not working MAC. Please help.
When user clicks on "Jan" button Jan month rows will unhide and when users clicks on "Jan-Hide" button all rows belongs to Jan will hide. The same way it applies for all 12 months
Sample Code:
>>> use code - tags <<<
When user clicks on "Jan" button Jan month rows will unhide and when users clicks on "Jan-Hide" button all rows belongs to Jan will hide. The same way it applies for all 12 months
Sample Code:
>>> use code - tags <<<
Code:
Sub Jan()
Sheets("TimeUpload").Unprotect Password:="1457"
Rows("25:47").EntireRow.Hidden = False
Sheets("TimeUpload").Protect Password:="1457"
End Sub
Sub Jan_Hide()
Sheets("TimeUpload").Unprotect Password:="1457"
Rows("25:47").EntireRow.Hidden = True
Sheets("TimeUpload").Protect Password:="1457"
End Sub
Attachments
Last edited by a moderator: