I know this is probably a longshot, but figured I would give it a go since you guys seen to be regular wizards when it comes to Excel.
I have a workbook, which dozens of people will be accessing via our Intranet. When they are viewing it, I do not want them to see the formulas, which the entire book basically is. But I cannot replace these with values because the workbook contains a combo box that directs values in the major spreadsheets.
Is there anyway to "hide" the formula without losing their functionality?
Thanks
I have a workbook, which dozens of people will be accessing via our Intranet. When they are viewing it, I do not want them to see the formulas, which the entire book basically is. But I cannot replace these with values because the workbook contains a combo box that directs values in the major spreadsheets.
Is there anyway to "hide" the formula without losing their functionality?
Thanks