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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,793
Messages
5,544,315
Members
410,602
Latest member
lidovi
Top