how to hide formula without protecting sheet

**xxxshankar** · 04-07-2009, 07:01 PM

Hi,
I have sheet with formulas. how I can hide this formula without protecting sheet? Is there any vba code ?

**shg** · 04-07-2009, 07:07 PM

No, there isn't.

**foxguy** · 04-07-2009, 07:31 PM

You can hide the column (or row).
If you just want the results to be invisible, you change the font color to the same color as the fill color.

**DonkeyOte** · 04-08-2009, 02:02 AM

You could also turn off the Formula Bar but obviously the end-user could just un-hide it again should they wish / know how... moreover it's likely it would make you unpopular amongst your colleagues ... generally speaking I'd say most users prefer to not have their XL environment altered without their prior knowledge.

**royUK** · 04-08-2009, 03:36 AM

Why not simply protct the sheet? That way not only can you hide the formulas but no-one can delete them.

**jolivanes** · 04-08-2009, 07:29 AM

xld had a solution for a similar problem here:

http://www.vbaexpress.com/forum/showthread.php?t=3394

HTH
John

**Denny George Skaria** · 09-22-2012, 04:13 AM

Alright, the question is to hide the formula in a cell/row/column as well as work normally in rest of the sheet. I tried a few VBAs but it wont be of much help if the macros are disabled. I'd to face a similar situation and this is what I did. Hope it helps.

SOLUTION:
Before protecting the sheet with Password-1, use "Allow Users to Edit Ranges" with Password-2 on rest of the cells where formula needn't be hidden.

Password-2 can be shared with the end user, while Password-1 still hides the formulas in selected cells.

You can also leave blank the Password-2, if needed.

Did it help??

Denny George