A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Track Changes without sharing

Thread Tools Display Modes
Old April 12th 10, 04:11 PM posted to microsoft.public.excel.misc
external usenet poster
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 ?

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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:01 AM.

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