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