jeffmfrank
Board Regular
- Joined
- Feb 28, 2002
- Messages
- 72
I'd like to add protection to a sheet, but the sheet includes code that hides and unhides rows depending on certain conditions that change periodically? Any suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
protecting a sheet with sheet altering code
- Thread starter jeffmfrank
- Start date
Excel Facts
Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
jeffmfrank
Board Regular
- Joined
- Feb 28, 2002
- Messages
- 72
In case anyone's interested, I solved my problem by figuring out how to add the code for sheet protection on and off around the sheet altering code.
Upvote
0
Similar threads
- Replies
- 5
- Views
- 296
- Replies
- 20
- Views
- 353
- Replies
- 11
- Views
- 610
- Replies
- 2
- Views
- 122
- Replies
- 8
- Views
- 828
