View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Hide cell formula without losing formatting abilities

Custom Format
;;;

"Matt" wrote:

I'm trying to hide the formula in for two columns in a worksheet. But
when I go to protect the sheet, the formatting abilities on all cells
are grayed-out. Is there a way to just hide the formula in a cell
without affecting the rest of the worksheet in anyway?