Hide cell formula without password protecting sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I would like to hide my formula without password protecting the sheet. I
know that there is a vba that should work. If you select say, cell A1 the
formula is =sum(b1:L12). Instead of seeing the formula I want to see the
value $312.51
Can a vba acheive the result without password protection?
 
In the formula bar you cannot hide the formula without protecting the worksheet.

You can change the formula to a value if you don't need the formula again.

Copy and Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP
 
Thanks but I don't want to condemn the formula by cut and paste. I want to
hide the formula using vba but I don't want to password protect the sheet at
all. I do not want to password protect the vba either. I would like to select
the cell and see the value not the formula
 
hide the formula using vba but I don't want to password protect the sheet

You don't have to password protect the sheet, but you do have to protect it.
Of course, all a user would need to do is unprotect the sheet to see the
formulas. There is really no point in hiding the formulas if you don't use a
password -- one mouse click and the user can see everything. There is no
other way. Basically it is password and hide or no password and no hide.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Back
Top