Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share and Protect question
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share and Protect question
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" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share and Protect question
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share and Protect question
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" wrote in message ... Thanks NickHK Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share and Protect question
Thanks Bob, had a look, very interesting... Great day further.
Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
Share Workbook/Protect Sheet Question | Excel Discussion (Misc queries) | |||
I need to share and also protect certain cells. | Excel Discussion (Misc queries) | |||
How to protect the share workbooK | Excel Worksheet Functions | |||
Share a workbook and protect | Excel Programming |