VBA to unprotect sheet, hide/unhide rows based on column A value=1, then protect sheet for multiple sheets

[Jason44136]

Greetings. I have a schedule tool created and struggling to find the right code. We have a sheet named "Associates" and will have a button on this sheet to link a macro module to update a number of other sheets. There are 7 protected sheets, let's just say "Sheet 1", "Sheet 2", "Sheet 3" etc for purpose of this thread. Each of these has Column A that pulls a value (1 or 2 - or blank) from the Associates tab. Looking to run this macro by clicking a button on "Associates" that will"

1. Unlprotect the specific 7 sheets
2. Hide/Unhide entire row IF value in Column A = 1
3. Protect the sheet again

Then if "Associate" tab is changed, the button would be clicked again to update the 7 other sheets again.

P.S. I know how to assign the module to the button, just struggling with the actual code to get 1-3 above executed.

 

[Jason44136]

Thank you, that works.

 

[Fluff]

Glad we could help & thanks for the feedback