View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
checkQ checkQ is offline
external usenet poster
 
Posts: 38
Default Hide cell formula without password protecting sheet

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?