| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect / Unprotect Sheet in Share Workbook Excel
I am using Office 2007.
I had done a VB project in Ms-Excel. I done all my coding using the normal Protect Sheet option. In between the program the code will Unprotect and protect the sheet. Now this sheet has to be saved in Shared Workbook. So, that all the users can update online at a time and put it on shared folder. When i saved it. The unprotect and protect commands / code are not working in Share Workbook. Please solve the problem. Regards, Venkatesh Solety |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect / Unprotect Sheet in Share Workbook Excel
Take a look at :
Features that are unavailable In Shared Workbooks In the Excel Help. Unprotecting a sheet can not be achieved in a shared workbook. On Sep 15, 12:52*pm, soletyvenky wrote: I am using Office 2007. I had done a VB project in Ms-Excel. I done all my coding using the normal Protect Sheet option. In between the program the code will Unprotect and protect the sheet. Now this sheet has to be saved in Shared Workbook. So, that all the users can update online at a time and put it on shared folder. When i saved it. The unprotect and protect commands / code are not working in Share Workbook. Please solve the problem. Regards, Venkatesh Solety |
| 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 | |||
| Macro to test sheet and workbook protect and unprotect status. | Excel Programming | |||
| Share Workbook/Protect Sheet Question | Excel Discussion (Misc queries) | |||
| Share a workbook and protect | Excel Programming | |||
| Excel VBA-Protect and unprotect sheet with BVA | Excel Programming | |||
Hybrid Mode
