Hide formulas

Adrae · Mar 26th, 2002, 10:52 AM

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

Dave Patton · Mar 26th, 2002, 11:01 AM

look at Tools Protection

Protect the cells that have formulas.

This will make the formulas invisible.

The protection is not very secure.

Jack in the UK · Mar 26th, 2002, 03:24 PM

To Add

Not to tread in

protection is very poor ecery day i get asked to crack such documents takes seconds...

Hide it will for about 2 seconds or less to advanced users.

Be careful

Mar 26th, 2002, 03:24 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	To Add Not to tread in protection is very poor ecery day i get asked to crack such documents takes seconds... Hide it will for about 2 seconds or less to advanced users. Be careful __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 10:52 AM	#1
Adrae Board Regular Join Date: Feb 2002 Location: Chicago, IL USA Posts: 306	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

Mar 26th, 2002, 11:01 AM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	look at Tools Protection Protect the cells that have formulas. This will make the formulas invisible. The protection is not very secure.