Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Track Changes without sharing
I have a spreadsheet which is a basic 'form' and will be completed and then
saved under different names. So used like a template. Then the completed form could be updated by different people (but doesn't need to allow multiple editors at same time). I want to force people to enter data in certain cells, and not others so I have protected cells. I want people not to mess with the sheet so I have protected sheet. I want to record who has changed what so I turned on track changes - but this shares the sheet and stops my macro to insert rows working. Can I track changes without sharing ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should be able to track changes without sharing workbook | Excel Discussion (Misc queries) | |||
Sharing | Excel Discussion (Misc queries) | |||
Sharing | Excel Worksheet Functions | |||
"Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) | |||
Sharing | Excel Worksheet Functions |