Unprotecting A Excell sheet

[senthilk]

Hi all,

I have protected some of the columns and a sheet of a EXCEL with a password. Now, the unprotect option in the TOOLs menu is not enabled itself. Also in the Format menu--> Cells menu also not enabled.

How would I unprotect my sheet now?

Thanks,
Senthil

 

[VoG]

You could try a macro like this (change password to the actual password)

Sub help()
ActiveSheet.Unprotect password:="password"
End Sub

 

[senthilk]

Hi Vog,
I tied that. still it is not working.