Email workbook without macros or vba module

[Rockymtnhigh]

I'm sure the answer to this question is elementary, but my kindergarten mind can't figure it out.

I want to send an excel workbook as an email attachment without any of the macros or vba modules showing. In other words I don't want the recipient to know my trade secrets or have access to same. I want the recipient to receive a sterile excel attachment with numbers only. Make sense?

I have saved a workbook without macros, but when I open it, the macros and vba modules still show up. Is this because the content in contained in my own excel on my own computer?

Thank you in advance.

 

[Greg Truby]

You can use the Tools | VBA Project Properties... menu option in the VBE to set a password. On the Protection tab check the Lock Project for Viewing checkbox and provide a password. Just do not forget the password as we wouldn't tell you how to break them even if we knew... I tend to write myself a hint in the workbook's properties (normally in the comments) just in case I forget.

 

[Greg Truby]

I have saved a workbook without macros, but when I open it, the macros and vba modules still show up. Is this because the content in contained in my own excel on my own computer?

Thank you in advance.

Um, then you didn't save it without the code. :wink:

In order to make sure a workbook has no code, you need to go in and inspect it in the project explorer in the VBE, making sure there are no modules, class modules or userforms and that ever sheet object's module and the workbook's object module are clean (this means no OPTION EXPLICIT either).

 

[Rockymtnhigh]

Um, then you didn't save it without the code. :wink:

In order to make sure a workbook has no code, you need to go in and inspect it in the project explorer in the VBE, making sure there are no modules, class modules or userforms and that ever sheet object's module and the workbook's object module are clean (this means no OPTION EXPLICIT either).

Thank you, Greg