Why this macro not running in 2007

[vipulgos]

Dear all,
This macro I was running in Excel2003 since many years

Sub unprotect_Click()
'
' unprotect_Click Macro
' Macro recorded 11-10-2003 by vipul
'
      
    ActiveSheet.Unprotect
End Sub

Now what's wrong with Excel2007
This macro is in personal.xlsb

This macro is still running with no problem
Sub protect_Click()
'
' protect_Click Macro
' Macro recorded 11-10-2003 by vipul
'
ActiveSheet.Protect

End Sub

Both the codes are there in personal.xlsb
but protect_click is working in any open workbook, but the unprotect_click is not working except that in personal workbook only

 

[vipulgos]

Let me attach my workbook personal.xlsb
Please save it in C:\Users\%username%\AppData\Roaming\Microsoft\Excel\XLSTART
add buttons for both in ribbon to call these macros protect_click and unprotect_click macros
and see what happens to you
here is the link for that personal workbook click here or https://app.box.com/s/yppi481qp7msf22ijqux

 

[vipulgos]

Somebody pl cime forward to help me out

 

[MARK858]

Afraid I won't be able to help as your file worked fine for me (obviously had to change the name so not to conflict with my PERSONAL file).

 

[vipulgos]

Is it possible by any mean, that I am using Win 7 (64 bit) an may have some issue with Excel 2007. If so why Protect_click macro is still running fine
Am I have to change the personal.xlsb to personal.xlsm?
And most importantly:
This macro is running while the personal.xlsb file is open and run the macro unprotect from ribbon in same workbook, i.e. personal.xlsb
but when I hide the personal.xlsb and then tries to run the macro unprotect_click into other book, say book1, then and then only, it gives me error.