How can I hide multiple worksheets that are in a workbook?

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I want to be able to hide certain spreadsheets within a workbook since I use
for calculating proposals and contracts that will be emailed to a client. I
do not want them to be able to see those additional worksheets since some may
not apply to their situation. I am not a visual basic programmer so need to
be able to do within basic functionality of Excel
 
If your clients will not be doing calculations etc with the sheet, they may
not really neet an actual working Excel spreadsheet. Just send them a
picture, or a .pdf

Vaya con Dios,
Chuck, CABGx3
 
Ron

Excel's internal security is very weak and hidden sheets can easily be opened.

The general rule is: if you don't want someone to find data in a workbook, do
not include that data in the workbook.

See the other responses for suggestions.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking multiple worksheets in one workbook 2
Linking Formulae Across a Workbook 2
hidden sheets 2
Create formula that combines numbers from multiple workBOOKS? 1
how do i hide a single worksheet in a workbook? 6
Editing Data in Multiple Worksheets/Workbooks 1
'Cannot insert object' message when I try to put a button on a worksheet 7
Multiple Worksheets 6

Back
Top