b3ta.com qotw
You are not logged in. Login or Signup
Home » Question of the Week » Off Topic » Post 1264874 | Search
This is a question Off Topic

Are you a QOTWer? Do you want to start a thread that isn't a direct answer to the current QOTW? Then this place, gentle poster, is your friend.

(, Sun 1 Apr 2001, 1:00)
Pages: Latest, 837, 836, 835, 834, 833, ... 1

« Go Back | See The Full Thread

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.
(, Mon 4 Jul 2011, 13:22, 1 reply, 15 years ago)
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.
(, Mon 4 Jul 2011, 13:23, Reply)
Did you protect the workbook or the sheet?

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

(, Mon 4 Jul 2011, 13:35, Reply)
Invalid column name,
Excel only goes up to IV, duh.
(, 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.
(, Mon 4 Jul 2011, 13:36, Reply)

« Go Back | See The Full Thread

Pages: Latest, 837, 836, 835, 834, 833, ... 1