Hello! I am looking for a macro that is probably easy to you macro users and difficult for me:
- I want to hide 10 of 14 worksheets in a workbook (hide all sheets except ones named "E", "K", "S", and "Chart").
- On "E" I want to hide all rows past 74 and all columns past P
- On "K" I want to hide all rows past 32 and all columns past P
- On "S" I want to hide all rows past 41 and all columns past P
- I then want to password protect the hidden sheets/cells and save a copy as a new name.
Can this be done relatively easily? Thanks!!
Brendan
Bookmarks