Solved: Password protection for Macro enabled sheet

[nagavineela]

Hi,
I have a workbook with 2 sheets. Each sheet has 5 macro assigned buttons.
How do i protect sheet?
When i click on any of the macro assigned button should not ask for password sametime should not allow user to edit excel rows and columns.
To edit manually, when we right click on sheet name tab -> unprotect sheet should prompt for "password".

Please help me at the earliest.

Thanks

[Bob Phillips]

Just password protect it and add code in the macros to unprotect it and re-protect it.

[nagavineela]

Hi XLD,
Thank you. The following is the syntax I used to protect and unprotect

Public Sub Workbook_Open()
Sheets("General Inst.-GroundFixed").Protect Password:="password", DrawingObjects:=True, Contents:=True, Scenarios:=True

and
Sub UnprotectAllSheets()
Dim wSht As Worksheet
For Each wSht In ThisWorkbook.Worksheets
wSht.Unprotect ("password")
Next wSht
End Sub

in Thisworkbook.

If I go and right click on the sheet name of excel and unprotect it is not asking for password.

Please help me.

Thanks,

[Bob Phillips]

Then that suggest it doesn't have a password doesn't it?

[nagavineela]

Yes.
Where should i place the code to protect with password and unprotect with password. I mean in Sheet1() or 'thisworkbook' etc.
Please guide me

[Bob Phillips]

In the button macros I would suggest.

[nagavineela]

Hi XLD,
Thank you very much. Its working after adding the password protection in each button macros.

Regards,