Share and Protect question

L

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
 
N

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top