Track Changes History Worksheet

In a shared password protected workbook, I would like to keep the History 
worksheet displayed all the time.  Currently, every time I open up the 
workbook, I have to go to Track Changes and click on List Changes in a New 
Sheet.  Thank you for your help!
0
Utf
2/5/2010 5:44:01 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

0 Replies
887 Views

Similar Articles

[PageSpeed] 11

Reply:

Similar Artilces:

tracking expenses for other people
Hi All, Is there an easy way to keep track of expenses purchased for other people? For example, I often buy equipment for work and other people (i.e. the kids) on my credit card and I would like to keep track of payments received so that I could make sure they balance out. Any idea? Cheers Stef See if http://umpmfaq.info/faqdb.php?q=36 or http://umpmfaq.info/faqdb.php?q=183 give you any ideas. There is no "one right way." It generally depends on how much trouble you want to go to and how frequent/many of these things you have going on. Lately I've taken to using my...

can I change the applied sales process?
I have several opportunities which had the wrong sales process applied to them. Is it possible to go in and apply the appropriate sales process, instead? (currently, if I go to "apply rule," the list is empty...) Thanks! aaron OK... So, the best I have is to close the opportunity and start over. Am I missing something better? "scootertig" wrote: > I have several opportunities which had the wrong sales process applied to > them. Is it possible to go in and apply the appropriate sales process, > instead? (currently, if I go to "apply rule," t...

Default Cell format of existing Worksheets got changed automatical
I am using MS Excel 2007. Most of my excel files saved with default cell format as General while creation; currently for the last two days when i open those files the cell content format is showing as currency format. Pls let me how to fix the same If you reference a cell that has a format (other then General), the reference cell will adopt the same format. -- Regards Dave Hawley www.ozgrid.com "NGBalaji" <NGBalaji@discussions.microsoft.com> wrote in message news:297839C7-D769-4623-94F1-2A77FD179E34@microsoft.com... >I am using MS Excel 2007. Most o...

Change Caption in Report
Hi all, I am trying to set up macros based on a huge amount of reports to automatically print the reports all at once. However, I would like to change the caption setting so that I don't have to keep changing the file name each time. Is there a way to do this? I am new to Access so I'm not sure how to set this up. For example, one report is called "rptCountrybySalesParent" and I would like each file to print out like "FrabySalesParent," "ItabySalesParent, "ChnbySalesParent," etc. I have the where conditions figured out, but the cap...

moving a row between worksheets
I want to write VBA code that does the following: When a value in column E is changed to "John" that entire row is moved to a worksheet (in the same spreadsheet) called "Assigned". Is this possible? Thanks! Amit, I've uploaded the file with code to http://Galimi.com/Examples/MS.xls Following is the code to be embedded as a Change event on the sheet that recognizes the word John: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 5 Then If Target.Value = "John" Then 'Move the column to the Assigned sheet ...

Calling a worksheet via a codename
Hi! I have a xla and a xlt. In a xla macro, i need to access a sheet of an instance of the template with a specific codename. The following code returns an error: ActiveWorkbook.xlsTheSheet even: ActiveWorkbook.worksheets(xlsTheSheet) What's the good way to acces the xlsTheSheet? Thanks, Thierry Paradis. just use xlThesheet it only works with the activeworkbook. demo'd from the immediate window: ? xlsThesheet.Name Sheet1 -- Regards, Tom Ogilvy "Thierry Paradis" <chezmoe200-5@yahoo.com> wrote in message news:%23JkqhRgPGHA.1124@TK2MSFTNGP10.phx.gbl... ...

Outlook Express 6 change text format to HTML
All my incoming mail is plain text, and I've tried everything to my knowledge to convert my email to receive html format. All my emails usually come in HTML format from before. Does anyone know how to fix this on the OE6 version? Thanks. All is okay!!! I found the answer on another email and it worked fine. >-----Original Message----- >All my incoming mail is plain text, and I've tried >everything to my knowledge to convert my email to receive >html format. All my emails usually come in HTML format >from before. Does anyone know how to fix this on the OE...

Put daily use worksheets in a toolbar in Excel
Hi, I have Excel 2003 with all updates. Seems to me I used to have a custom toolbar in the menubar area with shortcuts to files I used every day - but it was a long time ago. Is there a way to do that? Thanks, Marti Just record a macro that opens 'em, Marti. See: http://www.officearticles.com/excel/record_a_macro_in_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com "Marti" <MartiB@hotmail.com> wrote in message news:erghi19qjuba0d28jqkic1h5uou3b9uj0n@4ax.com... > Hi, > I have Excel 2003 with all updates. Seems to me I used to have a > custom t...

change a work order to a sales invoice
I am a new user in RMS and I am working with my auto department. We are working on oan older version of RMS (Pre 1.3). He primarily uses work orders when he has a new order. Once the work is complete on the auto he needs to bill it and take the items out of inventory. He is currently doing a multi-step process: 1) Processes the payment as a negative sale (an accounting nightmare) 2) Then he takes the WO number and does a sale refereing the number 3) Then he manually adjusts his inventory. 4) Because of the way he has processed them, the work orders remain open until he has time ...

Auto adjusting # rows between 2 worksheets
I have a spreadsheet where I import daily data into worksheet A. Sometimes there will be 5 rows of data and sometimes 1000+. Then inside the spreadsheet I have Worksheet B that runs some formulas based on Worksheet A. My question is how do I get Worksheet B to automatically extend or reduce the # of rows to match Worksheet A? Please help or give me some direction! thanks Kevin, You can have Spreadsheet B adjust the number of formula's programattically by cycling through the maximum used range in Spreadsheet A and inspecting individual cells for formula's. The followin...

Copy row to worksheet IF
I have a worksheet that I call data. I paste a set of data into this worksheet and I want certain rows(A:G) to be copied to another worksheet (Status) if Column B states Failed, Not Completed or No run. This is untested, so make a copy of your workbook to test with. But I think it'll work just fine for you. To put the code to work, open the copy of the workbook, press [Alt]+[F11] to open the VB Editor then choose Insert-->Module and copy and paste the code below into the module. Make any edits to the Const values that you see are needed. Close the VB Editor, run the ...

ERROR 80040E37 while trying to save changes offline
Error 80040E37 comes out when I am trying to save changes while being offline. Prehistory: I have moved CRM server on the same domain to another server and different OU. All the export, import, mapping procedures went smoothly. And now everything works just fine while being online, no errors during SQL replication. I have tried to remove replication registry entries from client machine, delete replication databases from client machine - no use. Nerijus ...

Copying charts
I'm using office 2000 SP3, win 2000. I routinely paste excel charts into word as enhanced metafiles and set the line thicknesses and font sizes in excel to produce similar looking charts. I have just installed SP3 and now I find that when the charts are pasted into word, the font and line thickness now appear much smaller than they did with SP2. Do you know why it has done this and is there a solution? Thanks Charles ...

HOWTO: Bulk change "Hide from Exchange address lists" under "Exchange Advanced" using ADModify or VBScript
Using ADModify: (http://www.gotdotnet.com/workspaces/releases/viewuploads.aspx?id=f5cbbfa9-e46b-4a7a-8ed8-3e44523f32e2) 1. Select the CUSTOM tab 2. Check Box "Make a customized attribute modification" 3. Attribute Name field, enter "msExchHideFromAddressLists" (without quotes) 4. Attribute Value field, enter "TRUE" to Hide from lists, "FALSE" to show in lists (again, without quotes) 5. Hit Go! ----------------------------------------------------------------------- Using VBScript: (http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct05/hey...

External Data Query
I have a worksheet that was originally set up with the Get External Data-->New Database Query menu option, I used ODBC data sources and entered my user id and password at the time. Since then, I use the Refresh Data menu option monthly to get new data. The password is embedded in the worksheet so I don't need to enter it a second time. However, I just changed my password on the database server and now Refresh Data gives me an ODBC error (Attempt to connect to the server failed.) I can't find a way to update the worksheet with the new password. Help please! >-----Origi...

no more new fonts may be applied in this workbook when changing fo
I get the error "no more new fonts may be applied in this workbook" when changing font (not adding a Graph). Any idea how to fix it. Thanks, Dan Shalom Micky, I tried that but did not help. Toda anyway. Dan "מיכאל (מיקי) אבידן" wrote: > Check this out: > http://support.microsoft.com/default.aspx/kb/215573?p=1 > Micky > > > "Dan" wrote: > > > I get the error "no more new fonts may be applied in this workbook" when > > changing font (not adding a Graph). > > > > Any idea how ...

Changing the volume of 2 sound files on the same slides
Hello all, I have background music playing on my PPT while I'm speaking. I would like to know how can I adjust the volume to on the background music to play softly underneath my voice. Thanks in advance! Geo I see you have posted a couple of times on this. The only method I have been able to use is Audacity, a FREE and quite comprehensive sound utility. Put your music (and voice, if you wish) into Audacity and alter the volumes to suit you needs, then export the file as a wav file for use in PowerPoint. You will need to spend a little time playing with Audacity t...

Changing Format of Access Field via Query?
HI all, Here is what i have, two Oracle tables across multiple schemas that I cannot change the actual format in the table. One table has the field = Text The other table has the field = Number/Decimal/10 Precision I need to link these two together to run some data and currently I have been making a temp table and changing the TEXT one to a NUMBER but am wondering if there is a way to change the Format of the TEXT one to a Number in a query which would save me from having to always be making a TEMP TABLE. Thanks in advance for any help you can give.. Aaron Try using an aliased column lik...

how to change numbers into words,
In excel how to change numberical data into english words, many times currency figures are required to be stated into english words as well so what is the formula for this problem, for example for US$ 5400 : $ Five thousand four hundred is the conversion into words. See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH RP (remove nothere from the email address if mailing direct) "Mukesh Dhoot" <Mukesh Dhoot @discussions.microsoft.com> wrote in message news:B59710A8-2377-4CF5-98B0-229933A3DE33@microsoft.com... > In excel how to change numberical data into e...

How can i change information on each post card
"laurza" <laurza@discussions.microsoft.com> wrote in message news:1AB33BA8-4499-491D-BC0B-D6043D82A5BA@microsoft.com... >> Usually by typing. But then you have not mastered typing yet or you could have given just a small amount more information about the program you are using and the actual problem. -- John G Wot's Your Real Problem? ...

Changing Yes/no box to combo box
I have a table that contains a field that is the data type Yes/no. Instead of having the traditional checkbox I am opting for the combo box. I have changed the display control to Combo box however when i go to add this to my form it does not have a drop down with yes or no....I know there is something little i must be missing. Another question is if i change it to this type of design is my code still going to be if me.xxx = True Then.....or will it change to if me.xxx = -1 Then? Thanks for your help as all my database just utilize the checkbox yes/no feature and not the combo box fe...

Change of bacground color in a Static Control
I wrote a dialog based application that changed the background color of a static control in the OnCtlColor () function. It worked in widows 98. Now that I upgrade my system to Windows XP, the background color of this static control disapeared. I can not understand why. Can someone answer that ? Thank you in advance. Rony jgfjfhg >-----Original Message----- >I wrote a dialog based application that changed the >background color of a static control in the OnCtlColor () >function. It worked in widows 98. Now that I upgrade my >system to Windows XP, the background color ...

Changed Data array #4
Anyone?? BUm -- Scottm ----------------------------------------------------------------------- Scottmk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=170 View this thread: http://www.excelforum.com/showthread.php?threadid=27290 ...

Change SMTP server through command line in Outlook
Hello! Is there any way to change the Outlook SMTP server information through command line? I have a laptop that I'm using at home and at work. At home I'm using a SMTP server that doesn't require authentication but at work I'm using another SMTP server that do require authentication. All help is appreciated highly! Regards Jimmy ...

Money 2002 Changing Investment to Savings account
Is there any way to do this? Am I missing the obvious? Thanks. Randy ...