I am creating a xls sheet to be distributed to multiple people outside of my
company. Is there a way to secure my macro and or buttons on the pages so
that my macro/button programming cannot be viewed by others ?
--
dr chuck

When you're in the code editor window, select from the standard
toolbar:

Tools VBAProjectProperties.

Select the Protection tab and click the 'Lock project for viewing'
checkbox. A password is optional.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=561644

....but keep in mind this will only prevent casual attempts to view the code.

It is not secure against anyone who really wants to view your VBA: there are a number of ways to get around the protection, and
these can easily be found by Googling the subject.

--
Tim Williams
Palo Alto, CA


"kev_06" wrote in message
...

When you're in the code editor window, select from the standard
toolbar:

Tools VBAProjectProperties.

Select the Protection tab and click the 'Lock project for viewing'
checkbox. A password is optional.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=561644

thanks

--
dr chuck


"kev_06" wrote:


When you're in the code editor window, select from the standard
toolbar:

Tools VBAProjectProperties.

Select the Protection tab and click the 'Lock project for viewing'
checkbox. A password is optional.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=561644