Morning all.
I just received an error while trying to run a macro. While this is the
first time I've operated on this workbook, I did check the information that
the error message provided and it doesn't appear to apply on this file.

Here is the message I received:
-------------------------------------
run time error 1004
you cannot use this command on a protected sheet. to use this command, you
must first unprotect the sheet ( review tab, changes group, unprotect sheet
button). you may be prompted for a password.
-------------------------------------

I went to the review tab, looked at the changes group, and there is no
"unprotect" option. I then clicked on the protect workbook icon, and it says
unrestricted access. I then tried clicking on that, and nothing changes-- as
it's already checked.

Any ideas on how to resolve this?

So far I've been able to run other macros with no trouble, so I'm a little
stuck/confused here.
Your helps are deeply appreciated.

The macro that I'm running is one that I obtained from Thomlinson.
Thank you.

In further investigation-- looking in the visual basic editor, "This
Workbook" through the properties window-- I've found that there is a
password. However, I do not see any way to remove this password-- as stated,
there is no option to unprotect the worksheet, or workbook, as it shows
unrestricted access in the review tab, changes group.
Any ideas?


"Steve" wrote:

Morning all.
I just received an error while trying to run a macro. While this is the
first time I've operated on this workbook, I did check the information that
the error message provided and it doesn't appear to apply on this file.

Here is the message I received:
-------------------------------------
run time error 1004
you cannot use this command on a protected sheet. to use this command, you
must first unprotect the sheet ( review tab, changes group, unprotect sheet
button). you may be prompted for a password.
-------------------------------------

I went to the review tab, looked at the changes group, and there is no
"unprotect" option. I then clicked on the protect workbook icon, and it says
unrestricted access. I then tried clicking on that, and nothing changes-- as
it's already checked.

Any ideas on how to resolve this?

So far I've been able to run other macros with no trouble, so I'm a little
stuck/confused here.
Your helps are deeply appreciated.

The macro that I'm running is one that I obtained from Thomlinson.
Thank you.

Hi Steve

Check all sheets in the workbook to confirm they are all unprotected.

Another way:
Try to click "Debug" when you get this error. Look at the highlighted line,
it may indicate which sheet the macro is trying to change. If not look at
the lines above.

Once you have identified the protected sheet you may consider to let the
macro unprotect the sheet, before manipulating the sheet.

Regards,
Per

"Steve" skrev i meddelelsen
...
Morning all.
I just received an error while trying to run a macro. While this is the
first time I've operated on this workbook, I did check the information
that
the error message provided and it doesn't appear to apply on this file.

Here is the message I received:
-------------------------------------
run time error 1004
you cannot use this command on a protected sheet. to use this command, you
must first unprotect the sheet ( review tab, changes group, unprotect
sheet
button). you may be prompted for a password.
-------------------------------------

I went to the review tab, looked at the changes group, and there is no
"unprotect" option. I then clicked on the protect workbook icon, and it
says
unrestricted access. I then tried clicking on that, and nothing changes--
as
it's already checked.

Any ideas on how to resolve this?

So far I've been able to run other macros with no trouble, so I'm a little
stuck/confused here.
Your helps are deeply appreciated.

The macro that I'm running is one that I obtained from Thomlinson.
Thank you.

Thanks Jessen.....
That was it. I don't know I didn't think of going through one worksheet at a
time. I had in fact checked debug, and saw which worksheet the error was
thrown on, but didn't think of activating that sheet, and looking at it to do
this.
Best.
8-D


"Per Jessen" wrote:

Hi Steve

Check all sheets in the workbook to confirm they are all unprotected.

Another way:
Try to click "Debug" when you get this error. Look at the highlighted line,
it may indicate which sheet the macro is trying to change. If not look at
the lines above.

Once you have identified the protected sheet you may consider to let the
macro unprotect the sheet, before manipulating the sheet.

Regards,
Per

"Steve" skrev i meddelelsen
...
Morning all.
I just received an error while trying to run a macro. While this is the
first time I've operated on this workbook, I did check the information
that
the error message provided and it doesn't appear to apply on this file.

Here is the message I received:
-------------------------------------
run time error 1004
you cannot use this command on a protected sheet. to use this command, you
must first unprotect the sheet ( review tab, changes group, unprotect
sheet
button). you may be prompted for a password.
-------------------------------------

I went to the review tab, looked at the changes group, and there is no
"unprotect" option. I then clicked on the protect workbook icon, and it
says
unrestricted access. I then tried clicking on that, and nothing changes--
as
it's already checked.

Any ideas on how to resolve this?

So far I've been able to run other macros with no trouble, so I'm a little
stuck/confused here.
Your helps are deeply appreciated.

The macro that I'm running is one that I obtained from Thomlinson.
Thank you.