Run Macros in Shared Workbook. Help !!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have created a shared workbook, containing protected worksheets with Macros.
By wrapping the Macro codes with as follow:

Sheets("My Sheet").Unprotect("My password")
Macro Code
Sheets("My Sheet").Protect("My password")

my macros work when the Workbook(Not Shared) is on the shared drive of my
Company.
When I set it as Shared Workbook, I receive an error message.
Can Someone Help me on this matter ?

Thanks in advance

regards

Paul.
 
In a shared workbook, you cannot do the following:
Write, change, view, record, or assign macros. However,
you can record operations in a shared workbook into a
macro stored in another workbook that isn't shared. In a
shared workbook, you can run macros that were created
before you shared the workbook; although if you run a
macro that includes an unavailable operation, the macro
stops running when it reaches the unavailable operation.

I got this from excel help. I typed in "macros and shared
workbooks". what came up were the "limitation of shared
workbooks". there were 9 catagories. I copied and pasted
the one on macros.
 
In a shared workbook, you cannot do the following:
Passwords
Assign a password to protect individual worksheets or the
entire workbook. Protection that you applied before
sharing the workbook remains in effect after you share the
workbook.
Change or remove passwords. Passwords that you assigned
before sharing the workbook remain in effect after you
share the workbook.

this is the part on pass words. probably what's giving you
the error.
 
Back
Top