OT: Spreadsheet Fun!

Fyron · #1 October 12th, 2005, 01:00 PM

Hide a backup of the SS somewhere!

inigma · #2 October 12th, 2005, 01:17 PM

What version of Excel?

As the spreadsheet owner, you can lock cells, columns, and rows with a password. Go to "format cell" then make go to the "protection" tab. Then go to Tools/Protection and protect the doc and it will protect cells that are marked locked. You can even protect the whole doc (the default) and then select a group of cells and unprotect, securing the whole document, but still allowing others to update the cells you specify.

I knew that official MS certification for MS Excel course that I paid $70 USD for would come in handy someday.

AgentZero · #3 October 12th, 2005, 01:35 PM

Actually it's Open Office program which is a lot like MS Office only better and free. I'm really looking for a way to exempt certain cells if need be so I can protect the cells I don't want fiddled with but still have them not apply in certain cases. Dunno how possible that is though....