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

 

[ParamRay]

.
.

Could it be that the sheet you're trying to unprotect has a password?

If so, try something like:

ActiveSheet.Unprotect Password:="qwerty"

 

[vipulgos]

There is no password as mentioned earlier and is reproduced below:

Sub protect_Click()
'
' protect_Click Macro
' Macro recorded 11-10-2003 by vipul
'
ActiveSheet.Protect

End Sub

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

I want to run both codes in any open workbook and hence stored in personal.xlsb
So, my question is why Protect macro runs nicely and why Unprotect is not?

 

[Andrew Poulsom]

Both procedures work fine for me in Excel 2007. In what way isn't the second one working for you?

 

[vipulgos]

Its really irritating for me. Its gives me error as under:
Cannot run the macro unprotect_click. The macro may not be available in this workbook or all macros may be disabled.
It was running nicely in excel2003.

 

[Rick Rothstein]

Its really irritating for me. Its gives me error as under:
Cannot run the macro unprotect_click. The macro may not be available in this workbook or all macros may be disabled.
It was running nicely in excel2003.

When you saved the XL2007 workbook, did you save it as an "Excel Macro-Enabled Workbook (*.xlsm)"?

 

[vipulgos]

I dont save a work book. I just open new book, say book1
Total vlank workbook, not yet saved.
But my macro protect is rnning nicely. Problem is with unprotect only.

 

[vipulgos]

please somebody help, before I uninstall 2007 and go back to old school of using Excel2003

 

[vipulgos]

Surprisingly it runs when I try to run in personal.xlsb workbook from ribbon,
but it is not running in any other workbook, when personal.xlsb is in hidden mode
still, protect_click is running....

 

[Peter_SSs]

I dont save a work book. I just open new book, say book1
Total vlank workbook, not yet saved.
But my macro protect is rnning nicely. Problem is with unprotect only.

Using Excel 2007 (& other versions) I have not been able to make either procedure fail, even under the circumstances stated here.