PROTECTING A WHOLE WORKBOOK

Gregula

Board Regular
Joined
Aug 11, 2006
Messages
156
Hi,

does anyone know how you can protect a whole workbook so that no-one can do any editing?

cheers,

Greg
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Gregula

Board Regular
Joined
Aug 11, 2006
Messages
156
Cheers for your reply.

However, using the protect workbook doesn't appear to work. You can still make any changes you like and save, re-writing any information.

I would like to protect the whole workbook, including every single cell! lol

This is so no-one can enter information unless they have a password (essentially having to come through me first). Is this possible?

I can't seem to save it as a read-only, you can still write.

If anyone can offer assistance, I would be most grateful!

Cheers!

Greg.
 

Gregula

Board Regular
Joined
Aug 11, 2006
Messages
156
Hey,

Sorry guys. I have figured it out. I just have to protect every single worksheet separately to get what I want.

Cheers! Sorry to bother you!
 

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening Gregula

Download my add-in from the link below - it has the functionality to implement Excel's worksheet protection on one, some or all worksheets at once with or without a password.

HTH

DominicB
 

Forum statistics

Threads
1,175,644
Messages
5,898,622
Members
434,719
Latest member
JoC

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
Top