• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel macro on MAC is not working

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 <<<
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:
Top