Disable viewing of macros

[Giri]

Hi,

1. In general, how can i disable users from accessing
macros for a particular workbook. I guess i should be
putting some code in the file open event and close event.
What is the command to disable the option.

2. I have a workbook with many worksheets. Each worksheet
is protected but for some cells that are allowed to be
edited by the user. Therefore, if a user wants to edit all
the cells then he/she should know the unprotect worksheet
password. How can i disable a user from accessing any
macro of the workbook unless the worksheet is unprotected.

Any help is appreciated. Thanks.

Regards,
Giri

 

[Andrew]

Hi Giri,

I'm not sure what you want to do, but I can tell you how to passwor
protect macros.

Open up your Visual Basic Editor (Alt + F11) and right click the macro
Then select VBAProject Properties and after that the Protcetion tab.

You should see a checkbox named Lock Project for viewing. Use th
checkbox and then enter and confirm your password below.

To protect sheets or workbooks, try Tools, then Protection and choos
the option that you like.

Hope this is useful

 

[Giri]

Hi Andrew,

Thanks. Your method does solve my problem.

Regards,
Giri

 

[Andrew]

Glad to have helped. :