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.