| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
make tabs inaccessable?
I am creating a quote template on 1 tab and would like to have my costing on
another tab in the same work book so that some cells will fill automatically. How would I keep my customers from seeing my costing on the 2nd tab? Excell 2003 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make tabs inaccessable?
Hi,
You can do all sorts of things:- Hide the sheet tabs Hide the sheets Make the sheets very hidden Apply sheet protectin But in the end all of these things are totally ineffective against anyone wanting to see your sheets and with the ability to do a Google search. If you want to keep a sheet private then don't send it. Mike "slowboat" wrote: I am creating a quote template on 1 tab and would like to have my costing on another tab in the same work book so that some cells will fill automatically. How would I keep my customers from seeing my costing on the 2nd tab? Excell 2003 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make tabs inaccessable?
Given the weakness of Excel's internal security the general rule is.........
If you don't want them to see it, don't include it in the workbook. You could make the costing sheet xlveryhidden but a determined snooper will find a way to make the sheet visible. Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 21:57:00 -0800, slowboat wrote: I am creating a quote template on 1 tab and would like to have my costing on another tab in the same work book so that some cells will fill automatically. How would I keep my customers from seeing my costing on the 2nd tab? Excell 2003 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make tabs inaccessable?
Thanks Gord, I appreciate it.
"Gord Dibben" wrote: Given the weakness of Excel's internal security the general rule is......... If you don't want them to see it, don't include it in the workbook. You could make the costing sheet xlveryhidden but a determined snooper will find a way to make the sheet visible. Gord Dibben MS Excel MVP On Tue, 18 Dec 2007 21:57:00 -0800, slowboat wrote: I am creating a quote template on 1 tab and would like to have my costing on another tab in the same work book so that some cells will fill automatically. How would I keep my customers from seeing my costing on the 2nd tab? Excell 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot make formulas work across tabs | Excel Discussion (Misc queries) | |||
| How do I make workbook tabs bigger? | Excel Discussion (Misc queries) | |||
| How do you make calculations between different tabs? | Excel Worksheet Functions | |||
| my tabs are hidden and can't make them show | Excel Discussion (Misc queries) | |||
| Is there a way to make the tabs at the bottom of a workbook two l. | Excel Discussion (Misc queries) | |||
Linear Mode
