Displaying only part of a workbook

Hi,
I have a workbook with a first summary sheet and 6 other sheets.
Calculations done on the last 6 sheets are automatically updated on the first summary sheet. The summary sheet is locked.
How can I send the workbook to other people without them being able to view (or have access to ) the last 6 sheets.
I want these people to only view the read only summary.
Thanks

Hi Bachi

try this,

Please Login or Register  to view this content.

Hi,
Will I still be able to view all the sheets in the workbook after I insert this code??
I only want my email recipients not to view the last six sheets.
I still need to work on all the sheets myself.
One last silly question.
I am not an expert so can you please give me directions on how to insert the code, (step by step)
Thanks for the help

Hi Bachi,

To insert code.
press alt f11 to open the code window.
now click on thisworkbook and copy and paste code

All sheets except "Summary" will be hidden
to unhide other sheets
click on sheet name in project explorer and click view from menu bar
click on properties window
scroll down to visible property and change xlsheetveryhidden to xlvisible
and that will now make that sheet visible.

Hope that helps.

I have done exactly as you suggested.
After I paste the code, I try going to tool/macro but no macro's are showing up to be activated. Therefore, my workbook is not affected at all
thanks