News:

A child can go only so far in life without potty training. It is not mere coincidence that six of the last seven presidents were potty trained, not to mention nearly half of the nation's state legislators.

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.

Print
Go Down Pages1
User actions

swolt

September 13, 2006, 04:22:43 PM
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

#1
September 13, 2006, 04:23:54 PM
Tools>Protection>Protect and Share Workbook

swolt

#2
September 13, 2006, 05:46:05 PM
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

#3
September 13, 2006, 06:09:30 PM
Can someone else though?
"Pinky, are you pondering what I'm pondering?"
I think so, Brain, but how will we get the Spice Girls into the paella?

BigDun

#4
September 13, 2006, 06:48:10 PM
File-Save As-Tools-General-General Options.
16:26:25 [DownSouth] I'm in a monkey rutt

swolt

#5
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.
A clever man commits no minor blunders.

Bennyhana

#6
September 14, 2006, 07:07:54 AM
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.
Print
Go Up Pages1
User actions