News:

BE ALERT!! The world needs more lerts.

Main Menu

Excel question

Started by swolt, September 13, 2006, 04:22:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

swolt

how do you lock an excel file so it is read only unless you use a password?

I have a file that I want everyone to be able to view but only me to edit.
A clever man commits no minor blunders.

Alice

Tools>Protection>Protect and Share Workbook

swolt

Quote from: Alice on September 13, 2006, 04:23:54 PM
Tools>Protection>Protect and Share Workbook

I already tried that. I give it a password but then if I open it I can edit and save without the password.
A clever man commits no minor blunders.

dazie

"Pinky, are you pondering what I'm pondering?"
I think so, Brain, but how will we get the Spice Girls into the paella?

BigDun

File-Save As-Tools-General-General Options.
16:26:25 [DownSouth] I'm in a monkey rutt

swolt

Quote from: BigDun on September 13, 2006, 06:48:10 PM
File-Save As-Tools-General-General Options.

that's it. Thanks!

and thanks to alice too. you get an A for being a girl.
A clever man commits no minor blunders.

Bennyhana

Quote from: swolt on September 13, 2006, 09:06:55 PM
Quote from: BigDun on September 13, 2006, 06:48:10 PM
File-Save As-Tools-General-General Options.

that's it. Thanks!

and thanks to alice too. you get an A for being a girl.

But at best a low C for software knowledge.