Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 19th 07, 06:57 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 3
Default 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   Report Post  
Old December 19th 07, 10:51 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default 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   Report Post  
Old December 19th 07, 10:03 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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   Report Post  
Old December 20th 07, 01:16 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot make formulas work across tabs Mark Hirsch Excel Discussion (Misc queries) 1 April 24th 07 01:04 PM
How do I make workbook tabs bigger? Leisa Excel Discussion (Misc queries) 2 October 13th 06 08:11 PM
How do you make calculations between different tabs? Andrew1029 Excel Worksheet Functions 2 August 18th 05 06:52 PM
my tabs are hidden and can't make them show Wendy Excel Discussion (Misc queries) 2 July 19th 05 06:37 PM
Is there a way to make the tabs at the bottom of a workbook two l. Jaytee Excel Discussion (Misc queries) 2 April 17th 05 06:15 PM


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017