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, 1 reply, 15 years ago)

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)