Share and Protect question

[Les Stout]

Hi all, i have a leave planner with code in each worksheet, that does
formating and unprotecting and re-protecting. I need this workbook to be
shared but it then stops the code from working. Could somebody please
help ??

Thanks in advance.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[NickHK]

Les,
I tend to avoid shared WBs, but AFAIK sharing means that you cannot edit the
VBA code but sharing in itself does not prevent code from running.
Depends what you code is doing, but I would imagine the users are making
changing to make code invalid. Then because you cannot edit/view the VBA, it
stops execution.

NickHK

 

[Les Stout]

Thanks NickHK

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[Bob Phillips]

Les,

Look at

Limitations of shared workbooks

in help to see the restrictions of shared workbooks.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Les Stout]

Thanks Bob, had a look, very interesting... Great day further.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***