Rave: Cell protection in Excel

The forum for ranting, raving, complaining and praising
Post Reply
User avatar
cards2468
Hall Of Famer
Posts: 14745
Joined: October 28 06, 11:10 pm
Location: LOVE IT OR LEAVE IT

Rave: Cell protection in Excel

Post 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.

User avatar
StatmanCrothers
Perennial All-Star
Posts: 6461
Joined: April 17 06, 6:50 am
Location: Boston burbs
Contact:

Re: Rave: Cell protection in Excel

Post 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.

User avatar
AdmiralKird
MBA, CPA, CFA, CFP, JD, PE, MD
Posts: 10178
Joined: March 7 07, 4:50 pm
Location: Tycho Crater, Luna

Re: Rave: Cell protection in Excel

Post 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.

Spider John
Hall Of Famer
Posts: 10952
Joined: May 18 06, 10:09 pm
Location: East of the middle of West Tennessee

Re: Rave: Cell protection in Excel

Post by Spider John »

I have a superior who does that kind of thing. Glad you are able to stick it to the man.

Post Reply