Can I unprotect a worksheet just for myself?

chandelirious

Board Regular
Joined
Sep 9, 2004
Messages
84
Hi, I wonder if you can help me at all.

I currently work on a large spreadsheet that is regularly used and worked on simultaneously by many people at once.

The majority of those working with it are not the most technologically minded people. As such, the worksheet is locked down quite heavily so that only certain areas can be edited by them.

However, when I'm in it - and it's a lot, and for long periods at a time - I need to unprotect the worksheet. During that time, others are working on it, and they frequently accidentally do things. I'm talking hiding columns, removing formulas, etc. They claim that they haven't done it, because they don't have access to the unprotected sheet. So I get the blame.

Ideally, I'd love to be able to say to them something along the lines of "You can't access the spreadsheet between 2.00 and 3.00pm every day," but that just won't work. Also, whereas I'm an office 9-5 worker, some of these are not, and will be accessing it out of office, so it's not even as if I can stay behind once a week to catch up.

So. With all that in mind. Is there any way that I can unprotect a worksheet just for myself? So that when the others are working on it, it is still protected for them, but not me?

Thank you so much in advance for any help you can offer!
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top