Page 1 of 1

Rave: Cell protection in Excel

Posted: November 12 10, 2:50 pm
by cards2468
So our site commander requested a new program be created to be idiot proof in allowing auditors to evaluate the health of a contractor. He delegated it down to an individual who delegated down to another individual who delegated it down to another individual who delegated it to me (pretty much they kept pushing off the assignment until it reached somebody capable of doing it). I created a nifty little spreadsheet full of coding all over the place that makes pretty pictures and colors and automatically compiles data and is made from pixie dust. It took me all week and the end result is pretty incredible. Everything outside of where the user inputs data is protected with the password being sent to all the supervisors who will work with it...

My supervisor is going to be presenting this to the site commander in a meeting monday. He has a habbit of taking credit for other people's work because he will crush anybody to climb the ladder. So I put it in the excel file that if you scroll over the title on the first sheet, a window appears giving myself credit for the work. This cell is also protected... with a password I am not sharing.

Re: Rave: Cell protection in Excel

Posted: November 12 10, 9:27 pm
by StatmanCrothers
cards2468 wrote: My supervisor is going to be presenting this to the site commander in a meeting monday. He has a habit of taking credit for other people's work because he will crush anybody to climb the ladder. So I put it in the excel file that if you scroll over the title on the first sheet, a window appears giving myself credit for the work. This cell is also protected... with a password I am not sharing.
nicely played.

Re: Rave: Cell protection in Excel

Posted: November 13 10, 1:33 am
by AdmiralKird
I had a professor once send out one of these to show how to do an assignment. Every cell was password-ed so you couldn't input your own data.

I uploaded it to googledocs then re-downloaded it and all the passwords were removed.

Re: Rave: Cell protection in Excel

Posted: November 13 10, 10:31 am
by Spider John
I have a superior who does that kind of thing. Glad you are able to stick it to the man.