Re: $$Excel-Macros$$ Error in Excel-VB macro

2016-05-12 Thread Mandeep Baluja
Great Paul On Tuesday, May 10, 2016 at 4:53:10 PM UTC+5:30, Paul Schreiner wrote: > > What I mean is: > > Protection can be at either the Workbook level, WorkSHEET level, or both. > Some of the worksheets are protected. > It LOOKS like the workbook protection flag is set, but the workbook isn't

Re: $$Excel-Macros$$ Error in Excel-VB macro

2016-05-10 Thread Paul Schreiner
What I mean is: Protection can be at either the Workbook level, WorkSHEET level, or both. Some of the worksheets are protected.It LOOKS like the workbook protection flag is set, but the workbook isn't really protected.Otherwise, I couldn't protect the workbook without first knowing the password

Re: $$Excel-Macros$$ Error in Excel-VB macro

2016-05-10 Thread ITP Abdulgani Shaikh
But, yes workbook is password protected, but earlier it doesn't gives error, but now when I am opening workbook it gives error for debug. On Mon, May 9, 2016 at 7:31 PM, Paul Schreiner wrote: > The problem seems to be that some protection flag for the workbook is set. > I'm using Excel 2010, and

Re: $$Excel-Macros$$ Error in Excel-VB macro

2016-05-09 Thread Paul Schreiner
The problem seems to be that some protection flag for the workbook is set.I'm using Excel 2010, and for some reason, on the Review tab, the Protect Workbook icon doesn't SHOW that it is protected. But I protected the workbook (with password) and then unprotected it. After that, the macros work c