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