If you have not put any code in the code module behind the first
worksheet, right click on the sheet tab, choose Move or Copy, select New
Workbook, check Create a Copy, and click Enter. The result is a
one-worksheet workbook with only the sheet you want and no code.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/27/2010 4:30 PM, G wrote:
I am currently using Excel 2003. I have written some VBA Code in a worksheet.

I have 2 worksheet. The 1s worksheet is required by users to see and use,
and the 2nd worksheet is not required by the user, but I need it for my VBA
code and other things.

Is there a way to distribute my excel sheet such that others will not be
able to see my code or 2nd worksheet?? 1st of all, I would like the VBA
code to be not available to my users to see. If I can I would like the 2nd
worksheet not available for them to see either. The removal of the VBA code
is more important to me.

I would appreciate any help you can offer.


Thank You,

G