View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Create a Command Button to Send E-Mails to selected recipients

Thanks Gord

I missed that one

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
With your workbook open and VBE project explorer open, right-clcik on your
Project/workbook and "Project PropertiesProtectionLock for viewing and give a
password.

DO NOT forget password.

Save and close the workbook before protection will take place.


Gord Dibben MS Excel MVP

On Sun, 27 Jan 2008 12:10:01 -0800, MeMe wrote:

Opps, one more, what is the best way to protect a macro from being
viewed/changed?