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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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,141,686
Messages
5,707,817
Members
421,531
Latest member
Fish0926

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