Open excel
open your workbook
hit alt-f11 (to get to the vbe)
hit ctrl-r (to see the project explorer)
with your project selected in the project explorer
Tools VBAProject Properties
Protection tab.
Zagrijs Venter wrote:
I have noticed that MS's templates and other Excel files received from other
sources needs a password to open the VBA source code. I have been unable to
find any assistance from OLH or figure it out on m,y own how to protect my
VBA source code. Any help appreciated.
--
Dave Peterson
|