Why this macro not running in 2007

ParamRay

Well-known Member

Joined

Aug 6, 2014

Messages

1,195

• Sep 20, 2014

• #2

.
.

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

If so, try something like:

ActiveSheet.Unprotect Password:="qwerty"

 

Upvote 0

vipulgos

Active Member

Joined

Aug 17, 2002

Messages

335

Office Version

1. 2010

Platform

1. Windows

• Sep 21, 2014

• #3

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

Code:

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

End Sub

Code:

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?

 

Last edited: Sep 21, 2014

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 21, 2014

• #4

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

 

Upvote 0

vipulgos

Active Member

Joined

Aug 17, 2002

Messages

335

Office Version

1. 2010

Platform

1. Windows

• Sep 21, 2014

• #5

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.

 

Upvote 0

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,463

Office Version

1. 365

Platform

1. Windows

• Sep 21, 2014

• #6

vipulgos said:

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.

Click to expand...

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

 

Upvote 0

vipulgos

Active Member

Joined

Aug 17, 2002

Messages

335

Office Version

1. 2010

Platform

1. Windows

• Sep 21, 2014

• #7

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.

 

Upvote 0

vipulgos

Active Member

Joined

Aug 17, 2002

Messages

335

Office Version

1. 2010

Platform

1. Windows

• Sep 22, 2014

• #8

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

 

Upvote 0

vipulgos

Active Member

Joined

Aug 17, 2002

Messages

335

Office Version

1. 2010

Platform

1. Windows

• Sep 22, 2014

• #9

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....

 

Upvote 0

Peter_SSs

MrExcel MVP, Moderator

Joined

May 28, 2005

Messages

63,880

Office Version

1. 365

Platform

1. Windows

• Sep 22, 2014

• #10

vipulgos said:

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.

Click to expand...

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

 

Upvote 0