Run-Time Error '1004':

I'm guessing that the Active Sheet is NOT Sheets("360Review") when the workbook is opened. It's possible that you, or someone else, saved the workbook with a different worksheet selected/active.

Try it this way

Please Login or Register  to view this content.

I'm still getting the same error, with the following line being the one that seems to be causing the issue:

.Range("4:104").EntireRow.Hidden = True

Edit: After doing some research, many people who had this issue discovered that it was from having comments in the rows they wanted to hide. I checked and I do not have a single comment on the file, so it shouldn't be that. I have also tried copying/pasting everything into a new workbook and that did not work either.

After stepping into the VBA, it took me to my code on the 360 Review sheet. A quick overview is that I have a "password" cell (B1) where a user enters their given password and the VBA for this page will hide/unhide rows depending on the password they enter. I attempted to make it so the user could simply hit enter after they type their password and it will run the macro (called Reveal) and that is where the Error was occurring with the hiding. I ended up moving my Reveal sub and the one I created for hitting the enter key into a module, which solved the issue.