I have been trying to find something like my problem in the KB, but no luck.
Here goes:
I have a shared workbook in which I have protected a worksheet and a macro
attached to a graphic. I wrote code that will unprotect the worksheet while
the macro is running, then password protect the sheet again as the macro is
closing down.
However, once I share the workbook, I can't run the macro! Is there any way
I can protect a sheet in a shared workbook yet still run a macro on it??
Thanking you in advance

There are somethings that you can't do in a shared workbook.

One of the things you can't change is the protection of a worksheet.



Duffer wrote:

I have been trying to find something like my problem in the KB, but no luck.
Here goes:
I have a shared workbook in which I have protected a worksheet and a macro
attached to a graphic. I wrote code that will unprotect the worksheet while
the macro is running, then password protect the sheet again as the macro is
closing down.
However, once I share the workbook, I can't run the macro! Is there any way
I can protect a sheet in a shared workbook yet still run a macro on it??
Thanking you in advance

--

Dave Peterson

I have been trying to solve a problem and it sounds like you may have the
solution. I want to create code that automatically unprotects the workbook
and worksheets anytime a macro is run and seals them back up when it is
completed. There are several hundered macros in the workbook and I do not
want to have to enter unprotect language at the beginning of each macro. Do
you know of a way to have it unprotect whenever a macro of any kind is run?

"Duffer" wrote:

I have been trying to find something like my problem in the KB, but no luck.
Here goes:
I have a shared workbook in which I have protected a worksheet and a macro
attached to a graphic. I wrote code that will unprotect the worksheet while
the macro is running, then password protect the sheet again as the macro is
closing down.
However, once I share the workbook, I can't run the macro! Is there any way
I can protect a sheet in a shared workbook yet still run a macro on it??
Thanking you in advance

I have been trying to solve a problem and it sounds like you may have the
solution. I want to create code that automatically unprotects the workbook
and worksheets anytime a macro is run and seals them back up when it is
completed. There are several hundered macros in the workbook and I do not
want to have to enter unprotect language at the beginning of each macro. Do
you know of a way to have it unprotect whenever a macro of any kind is run?

"Duffer" wrote:

I have been trying to find something like my problem in the KB, but no luck.
Here goes:
I have a shared workbook in which I have protected a worksheet and a macro
attached to a graphic. I wrote code that will unprotect the worksheet while
the macro is running, then password protect the sheet again as the macro is
closing down.
However, once I share the workbook, I can't run the macro! Is there any way
I can protect a sheet in a shared workbook yet still run a macro on it??
Thanking you in advance