Run Time Error 1004
 

Hi

I have a macro the protects and unprotect a workbook. When I manually
unprotect a workbook and try to do something I get the following
message:

"Run Time Error 1004:

The cell or chart you are tryint to change is protected and therefore
read-only.

To modify a protect cell or chart, first remove protection using the
Unprotect sheet command( Tools menu, Protection submenu). You may be
prompted for a password"

Would anyone have any ideas why this is happening?

Greg

Run Time Error 1004
 

This isn't workbook protection. It's worksheet protection.

So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your
code.

"Gregc." wrote:

Hi

I have a macro the protects and unprotect a workbook. When I manually
unprotect a workbook and try to do something I get the following
message:

"Run Time Error 1004:

The cell or chart you are tryint to change is protected and therefore
read-only.

To modify a protect cell or chart, first remove protection using the
Unprotect sheet command( Tools menu, Protection submenu). You may be
prompted for a password"

Would anyone have any ideas why this is happening?

Greg

--

Dave Peterson

Run Time Error 1004
 

Dave Peterson wrote:
This isn't workbook protection. It's worksheet protection.

So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your
code.

The error message comes up after I have done that.

Greg

Run Time Error 1004
 

I don't have another guess.

"Gregc." wrote:

Dave Peterson wrote:
This isn't workbook protection. It's worksheet protection.

So tools|Protection|Unprotect Worksheet (manually) or add the equivalent in your
code.

The error message comes up after I have done that.

Greg

--

Dave Peterson