changing the default for line connectors
I'm using the Flowcharting template and cannot figure out how to change the
default line color to black and the connector type to straight connector. I
can change individual lines once they've been made first by right clicking
and changing to straight, and then to format/line/color, but once I create a
new line, it automatically goes back to the square connector and blue line.
I've even tried the format/line/color before putting in lines, and it still
defaults back to blue.
...disable snap-to while dragging tab stops?
How do I drag a tab stop to arbitrary position without it snapping to the
tick marks on the ruler?
I tried holding down shift, ctrl, alt. None of them works. I even turned off
everything in the arrange->snap menu.
Set the tab to about where you want it, zoom to 200%, open the tab dialog and input
the number where you want the tab positioned, click set. The tab button can be
dragged to your toolbar by customizing. This is the best that Publisher can do...
Mary Sauer MSFT MVP
A few days ago while trying to balance one of my accounts, Money would start
hanging and I had to kill the process and created a LRD file. My file is
only 12MB and it has been fine until recently. I am using Money 2007.
I should have put my system specs. I have a P4 3.8GHZ w/ 2GB RAM running XP
Pro. When I have Money open, I typically only have Messenger, a browser, and
sometimes Acroabat Reader running also.
> A few days ago while trying to balance one of my accounts, Money would start
> hanging and I had to kill the process and created a LRD file. ...Shared workbook/Track changes
I have a Shared workbook wherein we use the Track Changes feature. Is it possible to view or jump to the cells that have been changed instead of scrolling up, down and sideways?
How can we change the default for the font in Publisher 2007? Or can we? I
keep getting some weird default font and want to change to Arial 10 and use
it throughout my newsletter.
Setting Text Defaults using Normal.pub
by Brian Kvalheim
Mary Sauer MSFT MVP
"Dutch" <Dutch@discussions.microsoft.com> wrote in message
> How can we change the default for the font in ...Change font colours while protected
How can I let other user's change the font colour without unprotecting sheet.
While protecting the worksheet Check the Format Cells Check box and enter
your protection password and give ok
Alt+T+P+P>>Allow All User of this Worksheet to:>>Check the Format Cells
Remember to Click Yes, if this post helps!
> How can I let other user's change the font colour without unprotecting sheet.
I Have excel 2003 and when I e...blue stop screen 0x0000007E
stop error code after windows installs drivers. this is new hdd and mobo but
problem persists.oxoooooo7e (oxf748eobf oxf78da2o8,oxf78d9fo8....was doing it
with last mobo and hdd...help please!!!
thanks one and all for your helping hands
> stop error code after windows installs drivers. this is new hdd and
> mobo but problem persists.oxoooooo7e (oxf748eobf
> oxf78da2o8,oxf78d9fo8....was doing it with last mobo and hdd...help
That *is* a driver issue. You are installing the incorrect drivers or need
to contact the manufacturer of said ...changing values in a Word Table
I need to read through a word document (Table)
The table has merged cells for Heading
Part No Description Price
A12344 Widget 1 � 5.99
WA123 Widget 2 � 6.45
D555 Thinggy 1 � 12.67
RT6161 Thinngy 2 � 17.50
I need to produce a Trade Price List
so say I deduct 20% from each value
Can't seem to get the VALUE into a a NUMBER format !!!
' Calculate Trade Price List
Application.ScreenUpdating = False
Dim x As Integer
Dim LastRow As Long 'get used LASTROW
La...OneNote 2010 sync to mobile device
I just upgraded to Office 2010 from 2007. My OneNote was syncing just fine
with 2007, but it does not sync with 2010. Will it sync? What needs to be
If not, then what steps are needed to downgrade OneNote 2010 back to 2007
...Change fonts in WordMail
I'm using WordMail as my default editor in Outlook.
I can't seem to figure out how to change the default
Any help would be appreciated.
Both of them are 2000-SR-1.
"Milly Staples [MVP - Outlook]" <MillyS@mvps.org> wrote in message news:<ug7sFFWSDHA.email@example.com>...
> What version of Outlook/Word are you using?
> Milly Staples [MVP - Outlook]
> Post all replies to the group to keep the discussion intact.
> Having searched the archives, Hergen <firstname.lastname@example.org> asked
...change customer purchase history
Is there a way to change customer purchase history? We have several
transactions that were rung under the incorrect customer. It would be nice
if we could assign those transactions to the correct customer.
The only way of doing this would be to run a sql query. In order to do this
you need an understanding of how to write sql queries as well.
If you have an understanding, you can use [Transaction].CustomerID and
[Transaction].TransactionNumber to assign those several transactions to the
Otherwise, I would suggest contacting your RMS Partner to help with this.
Rob...Tracking changes on OUtlook 2000 reolys
We are not able to turn on the tracking changes under
Outlook 2000. It works fine under Word, but Outlook has
it greyed out. We seem to have the same problem with
Outlook 2003. Outlook 97 works just fine. Any ideas?
...recipient policy stopped working
I'm seeing an issue in my Exchange 2003 environment where an admin will
create a new account and the recipient policy does not populate the users
email address. This just started happening a few days ago here in the US...
It happened in our UK office last week but I thought that might have been
user error on the admin. We are in mixed mode with Exchange5.5, which we have
been for almost a year. I did how ever remove some old 5.5 servers but the
last one I removed was almost a month ago, so i don't think it would be that.
I know you need to ask this question so yes th...Default View for Contacts in CRM for Outlook
We are utilizing CRM 4.0 for Outlook. One of our users is trying to get his
default Contact view be the CRM view instead of the Outlook view.
Unfortunately, this is not working for him.
Within Outlook, he went to CRM-->Options-->General and clicked on "Contacts"
where it says "By default, MS Dynamics CRM for Outlook uses standard Outlook
forms for activities....To use MS Dynamics CRM forms instead, select the
check boxes for those activities." However, he still gets the Outlook form
and has to click on "View in CRM" in order to view it in the right...Changing the colors
Is there a formula to change the color (of a cell or the written) with a
condition? Like, if the number is >10 is red, or something like that...
Look up conditional formatting in help (Highlight cells that meet specific
(remove nothere from the email address if mailing direct)
"Prado" <Prado@discussions.microsoft.com> wrote in message
> Is there a formula to change the color (of a cell or the written) with a
> condition? Like, if the number is >10 is red, or something like that....how to track changes from excel file?
saved an excel file multiple times only to learn errors later, can I view
earlier versions before each saved file? did not put on the track changes
Only if you saved earlier versions under different names (or same name, but a
> saved an excel file multiple times only to learn errors later, can I view
> earlier versions before each saved file? did not put on the track changes
...How do I stop a cc email to myself from going to deleted folder
Sometimes when I send an email, I want to keep a copy ofr myself. When I
enter my email address in the cc part, this always goes straight to the
deleted folder, even though I have my email listed as a safe sender. Any
On 13/03/2010 01:53, technochallenged wrote:
> Sometimes when I send an email, I want to keep a copy ofr myself.
Outlook automatically keeps a copy of every email you send in the Sent
There is no need to cc yourself.
"technochallenged" <email@example.com> wrote in
message news:D4...Changing the Password for the Mail Services Account
Is there an issues with doing this on an exchange 5.5 server. I think
not, but figure I would ask first.
Actually, yes there are issues.
In addition to changing the password from within User Manager, you would
also need to change the password on all of the Exchange Services in the
Services applet (Control Panel, Services) as they run under the context of
that user account, and also in Exchange Admin on the properties of the
Configuration container, Service Account Password tab.
"SRG" <firstname.lastname@example.org> wrote in message
news:ae...3197: The microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time
I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".
This isn't true because I have it on my local computer.
I've tried importing to a new DB file and I get the same error. The
original DB will not open to allow import (show table list) and show
er...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...File name change
I am very new with Exel
The following works, even though it might not be pretty.
But what I want to do is to be able to run this after changing the file name Follow_up.xls to, for example, 1234.xls.
The value 1234 is the sum of A3, so I put it in a variable - myFolder1 -
How do I enter it into the - Windows("Follow_up.xls").Activate - line, in the place of "Follow_up.xls"
Dim myFolder1 As String
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
Fal...Stopping the scroll bar
Hi all, this is my first time. I don't know if this is the right place
for this problem but here I go. I have created a template of an
invoice the size of an A4 and would like to stop the scroll bar moving
both horizantally and vertically in normal view just as if it was in
print view. Is that possible through VBA and if yes what is the code
that I would need to achieve such task.
Thanks in advance
Message posted from http://www.ExcelForum.com/
Not too sure what you are after but you can remove the scrollbars with
<Tools - Options> and then in the View tab, at the bottom,...Changing Background Color in a CStatic object
I'm trying to change the background of a static text string within a
CFormView dialog box. I can change the background of the dialog box, but not
the static strings, e.g., the dialog box is set to white, but the background
of the CStatic text string is still gray. I've tried trapping out the object
when I get the WM_ERASEBKGND for the dialog box, but no success.
Joseph Rooney wrote:
> I'm trying to change the background of a static text string within a
> CFormView dialog box. I can change the background of the dialog box, but not
> the static strings, e.g.,...OneNote 2007 Attachments from Outlook
Is there any way to have the attachements of an email sent from Outlook to
actually be attached to the notebook you file the note in once received?
I have THOUSANDS of attachments to emails filed, and all the actual files
are in the "Temp" subdirectory, and don't move when the page is moved from
the "Unfiled Notes" section.
Certainly makes synchronizing notebooks a problem.
...Changing a charts series order
In eariler version of excel I was able to rearrange the series order of my
charts. This allowed me to view data that existed under multiple data series.
How do I change the series order?
Additionally, how do I change the order of the series included in the legend?
You can change the series order via the select data dialog.
Select chart, Chart Tools > Design > Data > Select Data
The order of the items in the legend will change automatically.
Andy Pope, Microsoft MVP - Excel