G
Guest
Greetings:
I am constantly protecting and unprotecting worksheets and workbooks.
This was driving me totally nuts, so I made up (with major input from user
group) protect/unprotect toolbar icons and put them in a custom tool bar.
Now I'm looking for a quick, easy to read visual aid to indicate:
A: password protect status of current (active) worksheet
B: Password protect status of current (active) Workbook
What I'm thinking is perhaps toolbar icons that changes colour, or changes
from blank to an "L" to indicate locked, or ..................... ??
The indicators should work (be active) on whichever workbook/worksheet is
currently active.
I hope my question is clear.
Hopefully someone can help me out, before I'm totally bald.
I am constantly protecting and unprotecting worksheets and workbooks.
This was driving me totally nuts, so I made up (with major input from user
group) protect/unprotect toolbar icons and put them in a custom tool bar.
Now I'm looking for a quick, easy to read visual aid to indicate:
A: password protect status of current (active) worksheet
B: Password protect status of current (active) Workbook
What I'm thinking is perhaps toolbar icons that changes colour, or changes
from blank to an "L" to indicate locked, or ..................... ??
The indicators should work (be active) on whichever workbook/worksheet is
currently active.
I hope my question is clear.
Hopefully someone can help me out, before I'm totally bald.