Share and Protect question

  • Thread starter Thread starter Les Stout
  • Start date Start date
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
 
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,

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)
 
Back
Top