close

I have a spreadsheet that I need to share without the user being able to
unhide certain columns yet still have the ability to enter data in the other
fields. Any suggestions? Thanks
--
JerryS

Have you tried Locking all the the cells except those cells you want to
allow user input,
then hide the columns and protect the sheet with a password?

Rob

quot;JerrySquot; gt; wrote in message
...
gt;I have a spreadsheet that I need to share without the user being able to
gt; unhide certain columns yet still have the ability to enter data in the
gt; other
gt; fields. Any suggestions? Thanks
gt; --
gt; JerryS
I'm not sure how to do what you describe. Can you give me a simple step by
step?
--
JerrySquot;Robquot; wrote:

gt; Have you tried Locking all the the cells except those cells you want to
gt; allow user input,
gt; then hide the columns and protect the sheet with a password?
gt;
gt; Rob
gt;
gt; quot;JerrySquot; gt; wrote in message
gt; ...
gt; gt;I have a spreadsheet that I need to share without the user being able to
gt; gt; unhide certain columns yet still have the ability to enter data in the
gt; gt; other
gt; gt; fields. Any suggestions? Thanks
gt; gt; --
gt; gt; JerryS
gt;
gt;
gt;

Put your data in your two columns (say E and H).

Select all the cells on the worksheet.
Format all the cells as locked
(format|cells|Protection tab|Check Locked)

Select the cells that you want the users to enter data--don't include
formulas/headers/descriptions that they shouldn't touch.

Format|cells|Protection Tab|uncheck Locked

Now hide the columns you want to hide.
Select column E and Column H.
Format|column Hide

Now protect the worksheet.
tools|protection|protect sheet
use a memorable password.

==========
Be aware that worksheet protection is easily broken.

If that info in your two columns shouldn't be seen by the user under any
circumstance, don't do this in excel. It's protection is made for this.
Excel's protection is a nice way to stop formulas from being crushed in
error--not to protect intellectual property.
JerryS wrote:
gt;
gt; I have a spreadsheet that I need to share without the user being able to
gt; unhide certain columns yet still have the ability to enter data in the other
gt; fields. Any suggestions? Thanks
gt; --
gt; JerryS

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()