Workbook protection

[Soul Queen]

Okay I'm going to ask an elementary workbook question about excel.

I am making a workbook for myself that I want other people to see, but i want them to have only READ ACCESS, so they don't screw anything up.

How do I do this? I go to Tools, Protection,
Share and Protect Workbook????
Can I put a password on this???

Thanks

[JVO]

A Techno question, I know the answer to!!!!!!

It's a miracle!!!!!!

You can do this a number of different ways. If your workbook does not contain too many individual pages, I find it best to protect each sheet individually. It gives you a little more latitude on what you can allow.

Tools
Protect
Protect Sheet
Select the amount of protection you want
Enter password
Write password down so you don't lose it!!!! (I forgot to do this once and it was a major pain to figure out!)

Go to next sheet and repeat.

If you have too many sheets within the workbook for this to be practical, do this:

Tools
Protect
Protect Workbook
X both structure and windows
Enter password

I AM EXCEL MASTER OF THE UNIVERSE!!!!!!!

Those classes are finally paying off.

[Soul Queen]

Thanks JVO,

I thought I was excel master of the universe! :confused:

Guess not. Thanks for the help! Its appreciated. It saved me hours of trying to play with it.

[doublep]

if they hate you, they can SAVE AS and then copy the new file to the old file....
They would really want to hate you though