Shared Excel worksheet

[Linde]

Please Help,
I accedentely protected my worksheet by using the option "protecting and
share with other users". I saved the worksheet using the same file Name.
The problem I have now is that I can't change the Macro's using Visual Basic.
Is there any option to get to my macro's?

 

[Mike H]

Hi,

You need to un-share the workbook and you will be able to view/edit your
macros again.

Mike

 

[Linde]

Hi Mike,

Thanks for your answer, however

I already tryt this, but it is not functioning. The mainfile/shared file are
the same. so I (as far I can see) have only a shared worksheet to work with.
I saved the shared worksheet without password.

 

[Mike H]

Hi,

If I've understood correctly you clicked
Tools|Protection|Protect & Share
Clicked OK without entering a password and now you can't access your macros.
To overcome this click:-

Tools|Protection|Unprotect shared workbook
Then
Tools|Share workbook
Remove the checkmark from 'Allow changes........"
Click OK.
This will un-share the workbook and give access to your macros.

Mike

 

[Linde]

Hi,

You made my day, a real easy answer Thanks.

all best wishes and a good new year!

Harm