How to protect a file of Excel-Macro enabled workbook with password?

[PRADEEPB270]

I want to protect a file having enabled VBA codes and a Macro with the password as we easily do in excel files.
When it protect by password then macro or VBA do not work.
Is it possible to provide the password in excel-macro enabled workbook realted file having macro or vba codes?How?

[:) Sixthsense :)]

I believe you are talking about sheet protection, please confirm whether my assumption is right?

If so, apply protection via coding

Please Login or Register  to view this content.

Because in manual protection you don’t have the option to set the UserInterfaceOnly to True. UserInterfaceOnly will allow the codes to run but don’t allow the manual access to the sheet.

[HaHoBe]

Hi, PRADEEPB270,

in addition: the mentioned code line is volatile (not saved with the workbook) and would need to be used on every opening of the file (IŽd recommend to apply it on Activating the workbook as well).

Ciao,
Holger

[:) Sixthsense :)]

in addition: the mentioned code line is volatile (not saved with the workbook) and would need to be used on every opening of the file

Wow Really I am not aware of it Nice Tip

[PRADEEPB270]

Please refer to attach file (PKG) of excel-macro enabled .Can you protect this file with the password-"PKG1970"?
Means everytime,when I open the file,it should ask the password as in excel practice.But we sure,that all the macro or VBA codes work perfect after given password.
For an example,double click the cell no B9,then Sheet 5 should be open.

[HaHoBe]

Hi, PRADEEPB270,

you should amend your cod ein ThisWorkbook with the code to hide the sheet when leaving (all worksheets except Summary):

Please Login or Register  to view this content.

Ciao,
Holger