Thirith on 27/5/2009 at 10:10
I'm having problems finding solutions to the following problems. If you could help me or point me in the right direction (e.g. a *good* forum where people help with these things quickly and efficiently), that'd be much appreciated.
- Any way I can search a worksheet and find content even in protected cells? I did an evaluation spreadsheet which allowed colleagues to check entries and score them; on the individual colleagues' worksheet it carried over the relevant information, allowing them only to enter scores but not to change any of the stuff from the main sheet. However, my colleagues couldn't search for individual entries because the cells in question were protected.
- What's the easiest way to create buttons at the top of columns that auto-sort by the respective columns? I need the sort of functionality you've got in Outlook, where you can sort by the individual columns.
Al_B on 28/5/2009 at 20:51
Quote Posted by Thirith
If you could help me or point me in the right direction (e.g. a *good* forum where people help with these things quickly and efficiently), that'd be much appreciated.
Sorry - only know bad forums like this one :)
Quote Posted by Thirith
Any way I can search a worksheet and find content even in protected cells?
As far as I know Excel doesn't prevent searching even in protected (i.e. locked) cells. I quickly created one and tried it and had no problem finding values in locked cells even though I couldn't change them.
Quote Posted by Thirith
What's the easiest way to create buttons at the top of columns that auto-sort by the respective columns?
Highlight the first row, then just choose "Data / Filter / AutoFilter" from the menu and you get options to sort or filter on your spreadsheet. Alternatively, select a range and then choose "Data / List / Create List" but I've not used that as much to be honest.
Thirith on 29/5/2009 at 04:56
Quote Posted by Al_B
Sorry - only know bad forums like this one :)
Whoops - that *did* come out wrong, didn't it? :p
Quote:
As far as I know Excel doesn't prevent searching even in protected (i.e. locked) cells. I quickly created one and tried it and had no problem finding values in locked cells even though I couldn't change them.
Weird... It might be a problem with formulae vs. content. On the worksheet I mentioned, the names were carried over from the first worksheet and they were protected, but search wouldn't find them.
Quote:
Highlight the first row, then just choose "Data / Filter / AutoFilter" from the menu and you get options to sort or filter on your spreadsheet. Alternatively, select a range and then choose "Data / List / Create List" but I've not used that as much to be honest.
Thanks, will try this out.
LarryG on 4/6/2009 at 14:16
Another option to try is to use VBA for your searching. If it truly is a protection issue, with VBA you can turn the protection off behind the scenes while running the search, and back on again after.
belboz on 12/6/2009 at 10:21
dont columns get their own varibles set for them then you can write something to sort that varible that goes with the column you want sorting.