Alt:
More new people, maybe a rule that we have to be nice to them for maybe 48 hours. Someone should be responsible for a countdown.
(PsychoChomp, Mon 4 Jul 2011, 13:13, 3 replies, latest was 15 years ago)

Then when they're comfortable point out everything they said wrong in that 48 hours.

(PsychoChomp, Mon 4 Jul 2011, 13:13, Reply)

maybe not being nice
but not being a complete dick for no reason. Alternatively, we should just get rid of Bobby
( Vipros. clever got me this far, then tricky got me in, Mon 4 Jul 2011, 13:14, Reply)

Wait until he explodes from eating his own body weight in ribs.

(Bazongaloid, Mon 4 Jul 2011, 13:15, Reply)

if only
I'd be able to see the explosion from here
( Vipros. clever got me this far, then tricky got me in, Mon 4 Jul 2011, 13:17, Reply)

I don't think you should have to be nice.
But I think everyone should stop assuming any new people are Bert/Roger/CraigClodough unless it becomes somewhat obvious that someone fishy is up.
(Bazongaloid, Mon 4 Jul 2011, 13:16, Reply)

I think it's the load of accusations that bring those psychos back.

(PsychoChomp, Mon 4 Jul 2011, 13:17, Reply)

They do so thrive on the attention.
Chompy, I have another Excel question if you wouldn't mind.

I have a protected worksheet to stop my retarded colleages from deleting the formulas it took me ages to get right, but I would like them to be able to sort the columns not just filter them, and when I try it won't let me as the sheet is protected.

Any ideas on how this can be achieved?
(Bazongaloid, Mon 4 Jul 2011, 13:19, Reply)

Would it be possible to keep the entire workbook as read only?
That way, they could change it, but not save it?
( Agnostic Antichrist Baltimora, Mon 4 Jul 2011, 13:21, Reply)

That's one way of doing it, but it becomes a pain when you have to update it.

(PsychoChomp, Mon 4 Jul 2011, 13:23, Reply)

Exactly
I don't want them creating new versions every time the update it.
(Bazongaloid, Mon 4 Jul 2011, 13:23, Reply)

Ahh, fair enough

( Agnostic Antichrist Baltimora, Mon 4 Jul 2011, 13:24, Reply)

What I tend to do is have the formulars in a hidden sheet,
then get them to link back to the front sheet and password protect that, but that could be a lot of work if you didn't do that at first.
(PsychoChomp, Mon 4 Jul 2011, 13:26, Reply)

Yeah, it's a sheet that tells them how overdue things are based on when they were sent off
and how quick a turnaround was requested.
(Bazongaloid, Mon 4 Jul 2011, 13:28, Reply)

Um... tools/ protect sheet/ then just click the options you want them to have,
sort's in there but you'll probably need select etc so they can copy and paste.
(PsychoChomp, Mon 4 Jul 2011, 13:22, Reply)

Hmmmmm, I have sort ticked, which is why I was surprised.
May be I should try doing it with sort unticked and then do it again with sort ticked.
(Bazongaloid, Mon 4 Jul 2011, 13:23, Reply)

Did you protect the workbook or the sheet?

(PsychoChomp, Mon 4 Jul 2011, 13:25, Reply)

The sheet
Should I try the workbook?
(Bazongaloid, Mon 4 Jul 2011, 13:28, Reply)

zzzzzzzzzzzzzzzzzzzzzzzz

( chickenlady b3ta's very own Elizabeth Taylor, Mon 4 Jul 2011, 13:35, Reply)

Invalid column name,
Excel only goes up to IV, duh.
(PsychoChomp, Mon 4 Jul 2011, 13:36, Reply)

No the sheet should be the one that works,
not sure why it's not I'm afraid.

Other thing would be change the formulars to conditional formatting so they highlight the overdue things, that way they're pretty hard to fuck up.
(PsychoChomp, Mon 4 Jul 2011, 13:36, Reply)