Thanks for the replies. Is there anyway to disable the
macros? My spreadsheet has icons on them that have macros
assigned to them. I would like to inactivate the macros
(or icons) when I send the worksheet to another third
party.

-----Original Message-----
Len,

If you don't need them to see or use them, why not just
Remove/Export
them. You can then Import them back in after you send the
other person
the spreadsheet without the macros.

Other options:
At the very top of each of your modules, use:
Option Private Module
The above will hide the macros from the
Tools/Macro/Macros list

From the VBA Editor:
Tools/VBAProject Properties
Protection Tab
Lock Project for viewing
Enter passwords

The above will prevent someone from viewing the code in
the VBA Editor
without the proper password.

John

LenB wrote:

Greetings,

I would like to share a spreadsheet with another person,
but I would like the other person to not have access to
my
macros and would like to disable them or make
them "invisible" to the other person. Is this possible?

Thanks,

Len

.