Jason44136
New Member
- Joined
- Jul 8, 2019
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
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.
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.