Please help password protecting the file having macro already installed

[gm2612]

Dear Experts,

Just now I have taken help from Holger for making the VB code for the attached spread sheet. Now, I need to protect both sheets in this file with possword protection.

Can experts please help me? The file is attached. Macro already available is EVENT macro (fyi pls). I tried and failed.

I have already unlocked the cells to be used by the users.

Please help me. My sincere thanks for supporting to provide me this solution.

Thanks and regards,
gm2612

OTD Monitoring parallel.xls

[iqballud]

To protect the sheet, you can do by:
1. Block all sheet by click on the corner (Between A and 1) top side (the sign + will appear before you click it).
2. Choose Home tab, click on Format then click on 'Protect Sheet', enter your password to protect the sheet.

I enclosed the file with password protection: 123

Rgds,
Iqbal

[gm2612]

Hi Iqbal, thanks for the reply. But, I knew how to pretect the spread sheet with password protection under normal conditions. Now, I want to protect the sheet, and at the same time the macro shuld function without creating an error.

VBA Code, I learned for automatic password protection and removal is below

ActiveSheet.Unprotect Password:="123456"


ActiveSheet.Protect Password:="123456"

Now, the problem is that I do not know how and where in the existing macro these commands to be included. After completing this, the requirement is to -

User should be able to enter the data only in the fields where the cells are unlocked - columns A to G in sheet OTD. Other areas should not be modifiable for users. Sheet1 is totally protected, where the user can only take print of it. (3rd page of sheet1 - cells are unlocked for data entry)

Can you provide VBA code for completing this function please?

Thanks and regards,
gm2612

[HaHoBe]

Hi, gm2612,

instead of adjusting the portection in the course of the procedure allow VBA to be executed although the protection is set.

In ThisWorkbook:

Please Login or Register  to view this content.

The setting is volatile (won´t get saved with the workbook) so it needs to be initialized on every opening of the workbook.

Ciao,
Holger

[gm2612]

Oh MY DEAR GURU Holger,

Many thanks for the support. It is perfect. I am unable to understand what you have indicated as "The setting is volatile (won´t get saved with the workbook) so it needs to be initialized on every opening of the workbook" Can you please give what does this mean?

THanks and regards,
gm2612

[HaHoBe]

Hi, gm2612,

close the workbook, hold the Shift-Key and open it again. The Workbook_Open should not be executed and as that no macros would be allowed to run. So any change on Sheet OTD would lead to a run time error as you try to change locked cells on a protected sheet (Sheet1). Only when the procedure is run macros will be executed while you will get the message about protection if you try to change any locked cells.

Ciao,
Holger

[gm2612]

Thank you Soo much Holger.

With Warm Regards,
gm2612