I use office 2003. i want my cells formulas should remain hidden. but anyone can work on that sheet
I use office 2003. i want my cells formulas should remain hidden. but anyone can work on that sheet
select all cells
then format cells in check everthing
select cells with formulas in /format cells --hidden
protect workbook
http://www.techonthenet.com/excel/ce...e_formulas.php
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
hi martin,
but my protect sheet option is showing something else. when i am checking this one, i cant click any of the columns.
protect.JPG
watch this video
http://www.youtube.com/watch?v=S6MW9mWhHr8
Leave the Locked Checkbox as UnChecked and Give Tick in Hidden Checkbox alone and protect the sheet which will give access to you to edit the cell but wont display the formula.
Caution: There is a chance that you will type some thing in the formula cell since formula's wont be shown and which replace the formula to your newly added value.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
hi sixth sense,
the sheet is totally getting non editable after doing that.
Have you read this text?
Leave the Locked Checkbox as UnChecked and Give Tick in Hidden Checkbox alone and protect the sheet
hi sixth sense,
sorry for disturbing. yes i did. i am attaching the file here. please tell me if any problem there.
ryan,
I have merged both your threads. Its against forum rule 5 to duplicate threads.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi all,
i am new here. sometimes i cant trace my threads. thats why i have re send again. but slowly i am trying to find it out. i will take care of it in future. many thanks
Select the Summary Tab>>Press Ctrl+A twice (To select all cells of that sheet)>>Do right click>>Select Format Cells>>Under Protection Tab>>Click on both Locked and Hidden Check boxes and Uncheck it>>Click OK.
Select Range R4:S18 (Yellow highlighted cells)>>Do right click>>Select Format Cells>>Under Protection Tab>>Click Hidden Check box ALONE>>Click OK.
Apply Sheet Protection (Alt+T+P+P)>>Under Allow All User of this worksheet to>>Give Tick Mark in Select Locked Cells & Select unlocked cells>>Give Ok...
Now Check............
did you watch the video its clearly shown in that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks