security issues or providing security for macro enabled files

Hi,

I want to know the Security options/ Password options

I enclosed one template excel file which contains macro function, in which an end user to entry only raw_data sheet..(he should have all permission for that sheet)
He should have an read only access for customer, season,flavour sheet.. such that, the person need not insert/delete/update any records for those sheets..
& also he should not see the macro function.. (so that macro will be secured)
he just have to execute run button...
then he should get output as unique_records & duplicates sheets -macro will execute this function & script is also enclosed...

and then out put sheet - unique_records should be readable.. he is not suppose to entry/alter any data in that sheet..

But the developer who is developing that template of that excel with macro should have all access/permission.

Please suggest me about the security issues.....