USFengBULLS
Board Regular
- Joined
- May 7, 2018
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
Hello,
I am sure this is an easy question but would anyone know why I am getting a 1004 Runtime Error in my Code after I protected the Worksheets from the review Tab?
The code works fine when the sheets are unprotected, but I need to protect the worksheets so users can not adjust the formulas and contents of certain/most cells.
My code does work with a lot of these cells that are locked once Protected but I can't figure out why I am getting this Runtime 1004 error now.
Any Suggestions? Thanks.
I am sure this is an easy question but would anyone know why I am getting a 1004 Runtime Error in my Code after I protected the Worksheets from the review Tab?
The code works fine when the sheets are unprotected, but I need to protect the worksheets so users can not adjust the formulas and contents of certain/most cells.
My code does work with a lot of these cells that are locked once Protected but I can't figure out why I am getting this Runtime 1004 error now.
Any Suggestions? Thanks.