| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share a workbook and protect
I write some code in VBA to make a sheet automatically hide/unhide som ranges according to a n input box. Also I want to protect some part o the sheet so that the values can only be viewed but not editable Finally I share the workbook to a group so that others can enter thei names to edit their own part of the sheet. Questions: I do not know how to share a workbook in VBA code. If I share the workbook without VBA, I found that m "protect/unprotect" code in VBA conflicting with the Share Condition. Any help? Thank -- Jason ----------------------------------------------------------------------- Jasons's Profile: http://www.excelforum.com/member.php...fo&userid=1610 View this thread: http://www.excelforum.com/showthread.php?threadid=27554 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Share Workbook/Protect Sheet Question | Excel Discussion (Misc queries) | |||
| I need to share and also protect certain cells. | Excel Discussion (Misc queries) | |||
| Custom views, filters sensitive, in a share workbook an protect sh | New Users to Excel | |||
| How to protect the share workbooK | Excel Worksheet Functions | |||
| share a workbook but protect the formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
