View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rishi rishi is offline
external usenet poster
 
Posts: 14
Default protection,distribution

i have created a excel file with some code in it.... if i want to
distribute it so that the people can use the sheet, but no one should
be able to read the code. One way to do this is by going to project
properties and setting a password. But this wont protect the formulas
written in the sheet.
I have seen some sheets wherein a person can use the sheet but wont
know see any formula or code written in the sheet. Eg. file-new-
select LoanAmortization template(provided by microsoft) or any other

template. They do not have any code or formulas.. Please tell me how
to do that.
Thanks in advance.