Protect your Macro's?

[railguage48]

I am using excel 2007.

Is there a way to ensure that when you send an excel spreadsheet to someone else that you can ensure that they cannot see any of your macros?

The problem is that when I open an excel spreadsheet and goto my developer tab and then click on macros a whole list of macros show up.
The question above is to try and make sure that this list does not show up and I also hope that it prevents anyone from editing my macros?

Thanks.

 

[mikerickson]

Are you trying to prevent people from seeing your code, or are you trying to prevent all the macros being listed in the Run Macros dialog box.

If the latter, you could put Option Private Module at the top of each module. Alternatly, giving a macro an optional argument (that is never used in the macro) will prevent that macro from being shown in that dialog box.

 

[railguage48]

Are you trying to prevent people from seeing your code, or are you trying to prevent all the macros being listed in the Run Macros dialog box.

If the latter, you could put Option Private Module at the top of each module. Alternatly, giving a macro an optional argument (that is never used in the macro) will prevent that macro from being shown in that dialog box.

Thanks Mike,

I am going to do the first option you suggested .... along with the other suggestion given by Mr Kowz, I feel much more secure in sending out work to other folks knowing they cannot just copy your solutions from the VBA module.

Thanks again.