| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
hide
how would i be able to hide part of a sheet that has formulas on it. i would
like to email this sheet to others but do not want them to view the calculations? thanks. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
hide
Use sheet protection and set each of the cells with a formula in to hidden
(Format cellProtection and set Locked AND Hidden) set the cells you want the users to edit as unlocked. "help with excel" wrote: how would i be able to hide part of a sheet that has formulas on it. i would like to email this sheet to others but do not want them to view the calculations? thanks. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
hide
Hi
The safest way would be to copy the dataPaste SpecialValues to another sheet in the workbook, then mail this new sheet to others. -- Regards Roger Govier "help with excel" wrote in message ... how would i be able to hide part of a sheet that has formulas on it. i would like to email this sheet to others but do not want them to view the calculations? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Unhide Hide again | New Users to Excel | |||
| How do I hide a TAB? | Excel Worksheet Functions | |||
| Hide #DIV/0! | Excel Worksheet Functions | |||
| How can I hide #VALUE! | Excel Worksheet Functions | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Linear Mode
