Protection of a workbook

pbt

Well-known Member
Joined
Oct 18, 2005
Messages
1,613
How can I protect a workbook so no one can change any of the cells within the sheets.

I still need them to be able to access each sheet and be able to navigate either by scrolling or with the arrow keys or be able to highlight a row or column. Also I would need for them to be able to print any of the sheets.

Going to Tool > Protection > workbook > structure does not do it.

Thanks
h.h.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,165
Office Version
  1. 365
Platform
  1. Windows
Try protecting each sheet:
Tools|Protection|Protect Sheet...
 

pbt

Well-known Member
Joined
Oct 18, 2005
Messages
1,613
Tried that also. This does not allow the user to highlight rows or columns or to navigate with arrow keys.

The sheets have about 40 coumns and it makes it easier to view info in a row if yu could highlight a row by clicking on the row number then scroll to the right.
 

pbt

Well-known Member
Joined
Oct 18, 2005
Messages
1,613
Sorry, I figured out what I was doing wrong.

I had the "select locked and unlocked cells" chek box unchecked.

Works correctly for what I'm doing.

h.h.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,704
Messages
5,524,416
Members
409,576
Latest member
az168

This Week's Hot Topics

Top