macro and button security
 

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

macro and button security
 

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

macro and button security
 

....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

macro and button security
 

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