Hide a formula

[Veeru106]

Hi,

I am trying to hide my formula and as per me, I need to go to format cells and tick on protection and then tick on hidden box. then I will go to Review bar and protect sheet.

But my Protect sheet option in gray out..i am not able to click on that.

Please suggest any alternative way.

Thanks

 

[AlanSidman]

Without seeing your worksheet, it may be difficult to diagnose the issue.

 

[Veeru106]

Please find the sheet attached. thanks

 

[vletm]

Veeru106
Check word within [ ] ...

File is Shared.
UnShare file and after that You can do many things.
... Do not forget to Share again!

 

[Veeru106]

Sorry but everything in review tab is gray out now. How can I unshare it?

 

[vletm]

Veeru106
1) Tools->Protection->UnProtect Shared Workbook...
2) Tools->Share Workbook...->
from Editing Tab take [ ]Allow changes ... away ->
(( if there are users then You gotta 'Remove All Users' ))
[OK]->[Yes]

 

[Veeru106]

The only options I can see are Home,Insert,Page layout,Formulas,Data,Review,View and Developer...Please suggest

 

[vletm]

Veeru106 ... hmmm?
1) Open Excel, if not opened
2) Can You see of Excel Window some words (menu)?
3) I can see 'words' like:
Excel, File, Edit, View, Insert, Format, Tools, Data, Window & Help
(( Above of Your list of 'words'))
4) Try to focus that Tools
5) Continue from that with my previous Reply ....
>>> OR <<<
1) Your click that Your 'Review'
2) Share Workbook
... and continue like my previous Reply

 

[Veeru106]

Don't know but I think we are seeing 2 different sheets here..i cant see any Tools as mentioned in Point 3...nevertheless I can live with the present scenario...Thanks for taking pain and answering my question

 

[vletm]

Veeru106
I really cannot know which version do You use ...
maybe those can 'look different'?

I have those (photo below) 'texts' in top of my Excel-window. How about You?

And ... You named something like below 'texts' ... including 'Review'!

There is 'Share Workbook'!
Did You tried to 'use' ... 'look' something like those?
>> If not ... take a snapshot and send here, please.
I would like to see, something new for me too!