Setting 'Track Changes' as default

Hello All

I am using Windows 2K Professional & Office97.
I have a macro in an access mdb that outputs various files in excel format.

Is it possible either:

to use access VBA instead of the access macro to specify that the excel
'Track Changes' option is automatically set to 'True'; or
to specify elsewhere that all new excel files to have the 'Track Changes'
option automatically set to 'True'

In either case, the sub-options 'When' should be set to All, 'Who' set to
Everyone, and 'Where' should be left blank (i.e. applies to the whole
sheet)?

I'm sure this can be done, but just can't see how!
I would be grateful for any help.

Many thanks
Les



0
3/8/2005 2:00:54 PM
excel 39879 articles. 2 followers. Follow

0 Replies
411 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

Auto change formula in cells when source is changed
Good day experts; If specific cells have the same formula for example: C1 = Product( A1;B1) C16 = Product(A16;B16) C17= Product(A17;B17) And so on ... What formula should i write in C16, C17, ... so that: when the formula in the source cell, C1, is changed the formulas in C16, C17, ... would automatically change accordingly. I tried "=C1" it does not work Thanks in advance Carlo carlo wrote: > Good day experts; > > If specific cells have the same formula for example: > C1 = Product( A1;B1) > C16 = Product(A16;B16) > C17= Product(A17;B17) > And so on ... ...

vacation tracking calendar on exel sheet for 2006
...

setting up account for outlook?
Can anyone help me? Im new at this and would like to e-mail a friend whos over in iraq! Talk to your ISP - they will give you all the information you need to set up your account. We cannot. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Rasheem asked: | Can anyone help me? Im new at this and would like to e-mail a friend | whos over in iraq! ...

Favorite Folders reverts to default list when computer shut-down
I have no problem adding, deleting or moving folders in the Favorite Folders pane. The problem is that they all disappear and revert to the default list everytime my computer is shut down. So I have to keep adding the folders back in Is there a way to keep the shortcut folders in the Favorite Folders pane? ...

Changing a text field to a date field
Hi I know this is a problem for lots of people but I still cant find an answer. I have imported a text file into excel with a number field that displays credit card expiry dates as a 4 digit number. example 0408 so month + year. I have converted the number field to a text field so it doesnt drop off the first zero and now I need to convert it to a date field. Any nice easy simple ideas. Any help would be much appreaciated. Or direction to a question the same. Perhaps =DATE(100+RIGHT(A1,2),LEFT(A1,2),1) format as date -- daddylonglegs --------------------------------------------...

OWA Display Settings
Is there a method to clear the Web Access Display Settings (i.e. Color Schemes, Preview Pane setup) from the server side of the application for either a single user or all OWA users? Also, I've had several users report that if they've attempted to access their OWA mailbox in FireFox, they lose the way messages are normally displayed in the OWA client where each message basically has two lines, one line for who it came from and when and the next line for the subject. After logging to OWA with Firefox, all of the information is displayed on a single line. This is on a Windows...

Problem changing wallpaper on Vista
I am trying to change the wallpaper on Vista. I have a sub that works on XP with .jpg and .bmp images... Private Sub SetActiveDesktopWallpaper(ByVal sFileName As String, ByVal lStyle As Long, ByVal fForce As Boolean) Dim ad As ActiveDesktop Dim co As COMPONENTSOPT Dim wpo As WALLPAPEROPT Set ad = New ActiveDesktop 'check if AD is enabled co.dwSize = Len(co) ad.GetDesktopItemOptions co, 0& With wpo .dwSize = Len(wpo) .dwStyle = lStyle End With With ad ' set wallpaper style... .SetWallpaperOpt...

set a reminder to print or edit in an excel document
Is there a way to set a reminder to print part of a workbook or edit a workbook on a certain day. I need to print and edit a workbook on a certain day at a certain time, but I can never remember to do this. Is there any way of setting a reminder alarm or notification. Thanks > Is there a way to set a reminder to print part of a workbook or edit a > workbook on a certain day. ... If you have Excel, you might be using Outlook also. Both are part of Office 2003. Outlook has a "calendar" feature that pops up reminders the user can schedule. I use it all the ti...

Statment of changes in financial position
i will be a demo of GP 10 on Weds for a customer who has a requirement for a statement of changes in financial position. Is there any reason that this would be a problem in FRx as long as i know what GL accounts make up each row? Their sales and receivables are going to be maintained in another systmer - with that system providing a journal entry either weekly or monthly. THanks! Andrea: How did this come out for you, also have you done a Schedule of Changes Report?? Pretty standard non-profit reports. "Andrea Smiley" wrote: > i will be a demo of GP 10 on Weds for a cus...

Corporate Name Change
How does one change the name of a stock (and symbol) when a company (such as AOL) decides to do so Wade: Select AOL from your portfolio, right click and choose "see details" You can rename it and change the symbol there. Kevin "Wade" <anonymous@discussions.microsoft.com> wrote in message news:023701c395d4$c6129da0$a401280a@phx.gbl... > How does one change the name of a stock (and symbol) when > a company (such as AOL) decides to do so Thanks ... I get an error stating the ticker is already in use. How can I get around this (is there a global ticker li...

changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is completely missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, the table is empty and its .err file is also blank. If the .err files do not show...

And introducing... The Default Text Box Add-in!!
Default Text Box for Publisher 2002/2003 allows you to save defaults for text boxes in Publisher 2002 (which before now has been impossible) and to save these defaults for use in future publications (which isn't even possible with Publisher 2003!) Download it now from http://www.mvps.org/the_nerd/Publisher/add-ins.htm Go on, give it a go - it's free! -- Ed Bennett - MVP Microsoft Publisher http://www.mvps.org/the_nerd/ Before reading this message, view the disclaimer: http://mvps.org/the_nerd/disclaim.htm I don't want add-ons for 2002 - I want 2003! "Ed Bennett" <...

Changing Exch5.5 GAL columns in Outlook client view
Sorry if the subject line is a bit cryptic; anyway, in the Outlook client, if you display the 'Address Book' you get the following columns - name, business phone, office, title, company, alias, e-mail type, & e-mail address. How do you change it so you show the display name, business, extension, cell phone, & internet email address? Basically, how/where do you change the columnar data the client sees? Thanks, Mike Lawson Mike Goto View | Columns and there u can manage views... KJ "Mike Lawson" wrote: > Sorry if the subject line is a bit cryptic; anyway, i...

Dropdown Size: How do I change?
I have a workbook and after opening it on another computer, all the dropdowns are way too wide. And how can I have them show 20 items rather than the default of 8? Thanks, Craig Right-click the dropdown and you can change the 8 to any other number. To make it less wide, right-click it and drag the right/left border to the size you want. It MAY have something to do with the screen resolution on the other computers...? Bob Umlas "Craig Roberts" <Somewhere @ Lindstrom Minnesota USA> wrote in message news:e4jiOnVPFHA.1268@TK2MSFTNGP14.phx.gbl... >I have a workbook a...

How can I change primary display for presentation on multiple mon.
I want to hit F5 and have my presentation go to a different monitor. I have multiple monitors so my laptop display on a classroom screen. Can I change the default monitor that F5 points to? In article <5A95BBFC-B291-4A05-9E71-3F094B937ABB@microsoft.com>, Shorebilly wrote: > I want to hit F5 and have my presentation go to a different monitor. I have > multiple monitors so my laptop display on a classroom screen. Can I change > the default monitor that F5 points to? In the Slide Show | Set up show dialog, you can choose the monitor you want to display slide s...

Outlook keeps making itself Default
Hi, Everytime I start Outlook it takes over as default for email and addresses even though I have that option unchecked in outlook, and in IE I set OE Express as default, yet each time I launch outlook it takes over as Default, any ideas TIA Wayne ...

start app without setting focus
Hi, i want to start my app (modless dialog) and I do not want, that my application gets the focus. How can I realize that? I tried such tings like GetForeGroundWindow()->SetFocus, but nothing worked. Everytime my app has the focus (wether running hidden with tray icon or showed). Does anybody has some ideas how I can do that? thanks a lot, Holger -- www.kreissl.info In CDialog::OnInitDialog() return FALSE instead of TRUE -- With Regards Alok Gupta Visit me at http://alok.bizhat.com "I Believe this will Help" "Holger Krei�l" <n...

need basic help setting up a graph
Hello, I am trying to set up a chart of days and times. The X- axis shoul have the days of the week (mon, tues, etc) and the Y - axis should hav various times of the day. I would like to have a line from on specific time on one day to another specific time on the next. So, point would be monday at 10:00 and the next would be tuesday at 1:00 followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo your help Davi -- Message posted from http://www.ExcelForum.com Hi David, See my attachment. Is that the situation you explained? I use formula =IF(B2<0.5,B2+1,B2) in column ...

pointer changes from arrow to plussign
Somehow the pointer arrow in excel has changed from an arrow to a plus sign. How can I change it back to an a n arrow? That would depend upon where you are pointing the cursor. If anywhere on the cells portion of a worksheet, the cursor is a fat white plus sign. If pointing to menus, toolbars, sheet tabs or scrollbars the cursor should be an arrow. Are you saying your cursor "never" changes to an arrow? Gord Dibben Excel MVP On Wed, 14 Apr 2004 19:15:34 -0700, "gmohanco" <anonymous@discussions.microsoft.com> wrote: >Somehow the pointer arrow in excel has c...

Free/Busy data setting in OWA
We implemented Exchange 2003 and pushed a client setting to all users to extend the number of months available in free/busy to 12 months with a group policy. It works fine if everyone is using the outlook client when they are in the office. But, if a user works at home one day or goes to a conference and does anything that updates the free/busy data, the OWA overwrites the users free/busy data setting it back to 2 months of free/busy available. Where can I set the free/busy data number of months available, in OWA? Is it a policy setting? On Wed, 31 Jan 2007 13:54:01 -0800, SKS <sks...

Set Left and Right Margins in Headers and Footers
How do I set the left and right margins in headers and footers in Excel Select, File, Page Setup and the Margins tab. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Simon" <anonymous@discussions.microsoft.com> wrote in message news:FAD168AF-D83F-418A-8A72-4C0C28E8A192@microsoft.com... > How do I set the left and right margins in headers and footers in Excel Thank you for your response While I can see that this sets the Vertical position (Top and Bottom) of the headers and footers it does not set the...

Coping Saw w/ 5 Pc Blade Set
Price:$5.99 Image: http://thediscountlocator.info/image.php?id=B0006UOV8G Best deal: http://thediscountlocator.info/index.php?id=B0006UOV8G Coping Saw w/ 5 Pc Blade Set Zinc plated steel body construction. 3 ½ Lacquered hardwood handle is small enough not to get in the way yet large enough to get a good grip. Very thin and compact design makes it easy to get into tight areas. 5 tempered blades: 1- medium for cutting woods, 1-fine for thick metal or hardwood, 1- extra fine for thin metal or thin woods, 2- hacksaw blades for all metals. Blades are easy to replace, just unscrew the ha...

Email Sent from Workflow tracked twice in history
I have a workflow that sends an email to two CRM users. After the email arrives in the two users' inboxes, there are 2 history activities created for the email - one owned by the id we use for email routing, the other owned by the person who fired the rule. Any idea why this happens and what we can do to stop it? Thanks! Hi, Could you look at Settings - Organization Settings - System Settings. On the third tab you wil find the following: Set whether to exclude e-mails between Microsoft CRM users Exclude e-mail Yes/No Setting this option to No will create one e-mail activity for out...

Strange message tracking and NDR
Can anyone explain this tracking log? 19/10/2006 13:00 SMTP: Message Submitted to Advanced Queuing 19/10/2006 13:00 SMTP: Started Message Submission to Advanced Queue 19/10/2006 13:00 SMTP: Message Submitted to Categorizer 19/10/2006 13:00 SMTP: Message Categorized and Queued For Routing 19/10/2006 13:00 SMTP: Message Queued For Local Delivery 19/10/2006 13:00 SMTP: Message Delivered Locally to user@parkwaycc.co.uk 19/10/2006 13:00 SMTP: Non-Delivered Report (NDR) Generated The NDR was also unhelpful; the error code appears to be 5.2.1 but the message was only 32K. On Thu, 19 Oct 2006 15:0...

changing the message list in outlook 2003
i just upgraded from office 2000 to 2003. in the message look in outlook, it separates the messages by date. is there any way to turn this off, so i just have a long list of messages? Right click on the header in the message list, uncheck "show in groups." --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Lee Benningfield asked: | i just upgraded from office 2000 to 2003. in the mess...