Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 12th 10, 04:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2010
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should be able to track changes without sharing workbook Robs2107 Excel Discussion (Misc queries) 0 October 22nd 09 05:27 AM
Sharing Spring Excel Discussion (Misc queries) 1 March 11th 09 07:31 PM
Sharing Bridget Excel Worksheet Functions 2 February 20th 09 08:09 PM
"Track Changes" - Prevent turn off track changes to meet SOX regs Tammy Miller Excel Discussion (Misc queries) 2 July 31st 07 11:42 AM
Sharing Ishay Tal Excel Worksheet Functions 0 November 22nd 06 04:54 PM


All times are GMT +1. The time now is 01:52 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017