Ashley has attended:
Excel Intermediate course
Excel Advanced course
Word Advanced course
Word Intermediate course
Excel
If an area within a sheet has been unprotected to allow changes but the rest of the sheet has been locked how can you show the unprotected area so this can then be protected? Say if you forget which area is unprotected.
RE: Excel
Hello Ashley
Thank you for your question and welcome to the forum.
It appears that there is no easy way of getting Excel to select unlocked cells for you (i.e. the cells that people can edit/change in a spreadsheet when protection is applied).
It may be useful to note that when protection is applied to the spreadsheet, if you press the Tab key, Excel will only select cells that are unlocked/can be changed.
So if you wanted to identify these cells, you could press the Tab key, then say colour each cell so you knew which ones are unprotected.
Apart from this it appears you would need to write some VBA code to get Excel to select all the unprotected cells at once!
See http://spreadsheetpage.com/index.php/site/tip/selecting_all_unlocked_cells/
Amanda
