R
Roland.Case
Would love to simply hide a colum and use a password when "unhidden".
This is a worksheet wherein people enter data into it, but when
viewed, a column is hidden. Not that simple though.
Here is what I am doing now, but its cumbersome to say the least. Way
to automate or eimpligy this?
Undo protection to add data:
Open document, choose Tools, Protection, Unprotect, Enter password
Unhide hidden column:
F5 to open Go To box
Enter B2, OK
You wont see it but cursur in hidden cell
Choose from the top menu Format | Column | Unhide
Enter new data
Rehide column:
When ready to close choose Format, Column, Hide.
Reprotect document:
Tools, Protection, Protect Sheet, enter clear1, OK, then save document.
This is a worksheet wherein people enter data into it, but when
viewed, a column is hidden. Not that simple though.
Here is what I am doing now, but its cumbersome to say the least. Way
to automate or eimpligy this?
Undo protection to add data:
Open document, choose Tools, Protection, Unprotect, Enter password
Unhide hidden column:
F5 to open Go To box
Enter B2, OK
You wont see it but cursur in hidden cell
Choose from the top menu Format | Column | Unhide
Enter new data
Rehide column:
When ready to close choose Format, Column, Hide.
Reprotect document:
Tools, Protection, Protect Sheet, enter clear1, OK, then save document.