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

hi,

Only macro is secured with password. but how to enable it..
i want to know how to set that option...

on VBA editor click on tools then VBA project properties now window with two tab general & protection u will see, u need to click on protection then click on
chekbox to lock the project and finally set password.
to enable it press alt f11 +vbaproject(filename.xlxm) here u just click on + it will ask to enter password

Something like this;

All sheets are protected when file is open (even though "raw_data sheet" is protected all the cells are not).

Hi,

Thank you..
using above procedure, we can easily secure macro by setting the password..

Hi,

Thank you..
using above procedure, we can easily secure macro by setting the password..

Hi,

Thank you for the guidelines..
Exactly I want to protect the sheets, but I want to protect the unique_records sheet also.
unique_record sheet will be generating when a person press Run button(i.e when macro function is executed)
so how to protect that sheet.. whether for protecting that sheet macro should be include?
how to resolve this?

Hi,

Thank you for the guidelines..
Exactly I want to protect the sheets, but I want to protect the unique_records sheet also.
unique_record sheet will be generating when a person press Run button(i.e when macro function is executed)
so how to protect that sheet.. whether for protecting that sheet macro should be include?
how to resolve this?

Check uploaded file, make sure that all the passwords are the same;

Hi,

Thank you for the solution provided.
for all the sheets are provided with password, but i don't wont to set protection for raw_data sheet..
raw_data sheet should have all permission..
so i want to disable protect (password) sheet only for raw_data sheet & enable for remaining sheets...
is there any method..

Code amended;

Hi,

Thank you for the solution provided...