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 ?
0
Utf
4/12/2010 3:11:01 PM
excel.misc 78881 articles. 3 followers. Follow

0 Replies
866 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

Change Old Meeting Requests?
We've got a situation where a year or ago or so we moved from Exchange 5.5 to Exchange 2003. This change was accompanied by a domain change. The move went fine, but were are now finding that people who had reoccurring appointments on their calendars are getting error messages if they try to change them. These "meetings" are really just maintenance reminds and the like, they they don't occur very often. But if someone tries to do something that results in an e-mail being sent the message send fails. For example, if someone tries to change a staus from tenative to a...

OWA Change Password #2
Hi, I have Exchange 2003 SP1 in a Windows 2003 AD domain. OWA works great with SSL. I have enabled the Change Password button in the Options page. I have created the Iisadmpwd virtual directory, ... basically followed these articles: http://support.microsoft.com/default.aspx?scid=kb;EN-US;297121 http://www.petri.co.il/enable_password_changing_through_owa_in_exchange_2003.htm I see the button, click on it, the popup window appears (but first I have to log in again - cause I have only Basic Authentication turned on on that virtual directory). After I fill it out, trying to change the pass...

How do I change a default Message Delivery option?
I have a user who has managed to change his default email option to have "Expires after" turned on by default. I would like it turned off. I've tried turning it off and saving it as a template, but I would like it off in the default case... ...

Template Wizard with Data Tracking
I have been using this add-in just fine for about a year, gathering data from about 20 users onto an Excel Database by having them all use the template. But I recently made some changes and then began having the following problem: After a worksheet has been created using the template, and saved as a new record in the database, and then we want to go back in to change the record and update it in the database, the option does not appear to update the database; the only options continue to be to create a new record or to proceed without saving to the database. It is as though the sys...

Change AND to OR
Like change the criterion of search of AND to OR in the filters of the CRM? Thanks, no way to do this,.....either create your own app or purchase one from an ISV, for example: http://www.c360.com/SearchPac.aspx -Gary "Eduardo Testa" <etesta@voipgroup.com> wrote in message news:OItXnbGOEHA.1348@TK2MSFTNGP12.phx.gbl... > Like change the criterion of search of AND to OR in the filters of the CRM? > Thanks, > > ...

Time Stamp-With Change
I seen many posts on in this forum on time stamps. My problem this tha in a1:a10 are going to be the entries. I need upon each entry into eac cell a time stamp in b1:b10, but I need this to be hard coded so that i I went back in a1and made a change it wouldn't change the time again i b1. Regards Anton -- Antony ----------------------------------------------------------------------- AntonyY's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1669 View this thread: http://www.excelforum.com/showthread.php?threadid=32046 Antony Try this in a worksheet module....

Change Payee Name for an Epay
Is it possible to change the name of an epay payee? My example is, my credit card company was BankOne. It has changed to Chase. Same account number, same mailing address, same everything except the name. I can't find any way to just change the name to Chase and keep the history. It's not directly possible. If it's important to you, I would: 1. Disable online services. 2. Create a new payee called Chase. 3. Move the BankOne payee to Chase (Right click on BankOne in the payees place & select move). 4. Enable online services. Good luck! -- "Tommy Flynn" &...

How to hide my computer in start menu without restart?
Hi, My program try to hide the item "my computer" in start menu by modifying registry value "Start_ShowMyComputer" to 0, but "My computer still appear in Start menu. I am sure there must be one way to apply the changes without system restart because I can do it by the dialog "customize start menu" provided by win xp without system restart. Does anyone know how to do it? Thanks. -- Nothing impossible, Nothing sure Would broadcasting a WM_SETTINGCHANGE message it do the trick? AliR. "NianHawk" <NianHawk@hotmail.com.invalid> wrote ...

Message Tracking #6
What is the best way to check if your exchange sometimes doesn't accepts mail (delay) or doesn't send mails correctly (delay) Message Tracking ? But how do you actually do this Kind regards Guillaume Coign� "Guillaume Coign�" <guillaume.coigne@trust-it.be> wrote: >What is the best way to check if your exchange sometimes doesn't accepts >mail (delay) or doesn't send mails correctly (delay) Message Tracking ? >But how do you actually do this Assuming you're asking about messages leaving your organization, the SMTP protocol logs are the place to ...

Sharing Calendar
I have tried to share my calendar from my desktop to my laptop, via email. It sends out, and the laptop message received has been accepted but all the information sent to my laptop does not show up. I have correctly set it to the calendar. Am I wrong, or should all my appointments from the desktop show up on the laptop? Both are running Outlook 2000, although the OS on the desktop is Win2000 and on the laptop it's WinXPPro but I doubt that has anything to do with it. I really don't want to copy the complete .pst file over as I'm not receiving my emails on the laptop - I just wa...

Track Changes compatibility between versions of Excel
I'm planning to undertake a project which involves Excel sheets created in Excel 2003 and tracking the changes made to those sheets via Excel 97. Does anybody know of any problems with the compatibility of this function? This would help me out a lot. Thanks. ...

How do I track half days in the attendance tracking template?
I've just created an attendance tracking template in Excel, however realized that there isn't an option to track half or quarter days taken off. Does anyone have any suggestions? A lot depends on how you've laid out the data. Instead of tracking whole days, can you track hours? 8 for a full day, 4 for a half day, etc. ...

Color Changes
Have inserted company logo in publisher file. It is in eps format and looks/prints fine from illustrator but will not look/print in the right color from publisher? Can I fix this? Whilst attempting to develop brick-based storage technology, Ed reads a message from Becky N <becky@markardesign.com> > Have inserted company logo in publisher file. It is in > eps format and looks/prints fine from illustrator but > will not look/print in the right color from publisher? Make sure you are using a PostScript printer (or using a PDF file as an intermediary) -- Ed Bennett - MVP Micr...

Tracking GST/VAT in MSMoney Standard
I'm new to Money & processing small business accounts. Had no problems tracking & reporting VAT in Quicken & havegot Money to calculate VAT with each relevant entry. Somehow just not finding a report that shows VAT totals, taxable income etc. Please HELP!!!!! ...

isa owa exchange2003 changing port?
is it possible to work with other port than 80 or 443? what should i configure in isa? "shamunmic" <shamun@mekorot.co.il> wrote in news:ONWlypkwDHA.3144 @tk2msftngp13.phx.gbl: > is it possible to work with other port than 80 or 443? > what should i configure in isa? I believe if you change the port of OWA it becomes an unsupported configuration. Regards, -- Arlo Clizer Exchange MVP FAQ located at http://www.swinc.com/resource/exchange.htm Newsgroup archives at http://groups.google.com ...

Need to copy chart of excel to powerpoint file without the other s
Hello, I have excel file. in the excel there is three sheets: test1, test2 and test3. in the test1 sheet I have chart with parameters. when I copy the chart and the parameters in the sheet 'test1' to powerpoint (with past special) and choose the 'microsoft excel chart object' it past the chart to powerpoint and I can change the parameters inside but the problem is that it also copy the other two sheets: test2 and test3. I want when I copy the excel chart to powerpoint that it will copy only the test1 sheet (without the test2 and test3 sheets), because this is what I marke...

Hex value change from o to �
Hi, I have load Cobol flat file into sql table by bulk insert. There a packed comp-3 filed. I am trying to convert to Hex decimal. The flat file was like 'o' o = 9c in hex. after bulk insert into sql table the value became '�' the last char � = 3a in hex. any ideas why the last char changed after bulk insert? Thnaks, Mecn (mecn@yahoo.com) writes: > I have load Cobol flat file into sql table by bulk insert. > There a packed comp-3 filed. I am trying to convert to Hex decimal. > > The flat file was like 'o' o = 9c in hex. &g...

Sharing violation on a file just closed
Any idea why I would get a sharing violation upon opening a file with CFile::Open on a file which was just closed without error using fclose ?? Close file code: if ( fclose ( f ) ) AfxMessageBox ( "Error on fclose of log file" ); Open code: if ( FILEIN.Open ( XFER_FILENAME_LOCAL, CFile::modeRead, &inException ) ) { // normal processing } else { inException.ReportError (); } Where the ReportError above displays: A sharing violation occurred while accessing C:\Program File\CB_Software\Program\CB_grabber.log Thanks. - Dave Can't diagnose with the info prov...

PO Receive should let me change price before commit
When receiving a PO and changing the price using 'New Price' column and receiving some or all items and then printing labels the old price is printed on the labels. I do not want to 'Commit' first because I need to use 'Issued/Received on this order' bullet in label printing because I may have received on this order before and may be receiving more in the future.Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the m...

Outlook 2000: Any way to track Calendar access
I've opened up my Calendar for anyone to read in Outlook 2000. Is there any way to track who accesses it? ...

How to track meetings for a task?
How would you suggest to charge meeting time to a my Timesheet task? TIA! Depends on if it's a planned meeting or informal. I typically just create a bucket task through the entire schedule for "Meetings" or book it to PM time. You may also opt to create a distinct line item bucket task for status meetings as opposed to other ad hoc meetings. If it's a big phase gate meeting, I may list that specifically as a line item, but for anything less than that, it becomes too granular for effective management. - Andrew Lavinsky Blog: http://blogs.catapultsystems...

track Shipment
Is it possible to set up the Track Shipment so when you click on TRACK it is automatically bring up a browser with the tracking information? For UPS what will be the URL to set up? ...

no longer can change width height in format picture
I can no longer can change width and height (overtyping) in format picture. I am using Word 2003 and have a image in front of me. Could do it previously but reloaded my program after replacing hard drive? help ...

Problem in message tracking center
when i use message tracking center to search some e-mail in our exchange 2003 server,i find that some e-mail cann't to be in the search result.For example,I sent 3 email to my stuff,and he received all. Then i tracked them in the message tracking center ,only the first email could be tracked. Thanks for ang reply! ...

Tracking of Birthdays in CONTACTS
In my contacts, I also key in their birthdays. How to make Microsoft Outlook tracks and alert me of Contacts' birthdays? outlook should create the appointments when you save the contact. if it doesn't try http://www.rsoutlook.com/us/prods/prod05.html -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook &am...