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
- Jul 25 Fri 2008 20:45
Locking and Hiding Columns
close
全站熱搜
留言列表
發表留言