How do I change the default color of the tag for insert c... #2
This issue has me perplexed. I don't enjoy the default red color tag while
doing an insert comment. Does anyone know how to change the default color?
Thanks in advance.
You can't change the color. You could use the Drawing Tools to draw a tiny
little triangle over it (or them) and then give it a fill color.
See http://www.contextures.com/xlcomments01.html for more on comments.
> This issue has me perplexed. I don't enjoy the default red color tag while
> doing an insert comment. Does anyone know how to change the default c...Help with labels and lines in chart
i am tracking a few things and i wanted to make some objects in the my
chart reposition dynamicly as i change the scale
i dont care if i have to do a little clean up but just that the
postions stay correct
i have attached a picture
any suggestion would be greatly appreshated
|Filename: Unti.png |
|Download: http://www.excelforum.com/attachment.php?postid=5056 |
All of a sudden today when I hit reply to messages in my inbox, or forward
messages in my inbox, they are automatically removed from my inbox. Of
course they remain in my sent box, but I prefer to keep the original message
in my inbox as well.
I have not changed settings at all on this but for some reason it started to
do this today. I cannot find any reference to this in the help file online.
I do NOT have it set to view unread messages only.
Sounds like you're looking at a view or search folder that's filtered to =
show only unread items.=20
Sue Mosher, Outlook MVP
...PivotChart data labels
Is it possible to have data labels as a percentage on a pivotchart ?
What kind of chart are you making - pie, line, bar, ....?
What version of Excel are you using?
You can add data labels to pivot chart by choose Chart, Chart Option, Data
You can add a custom label by calculating the percent in the data range of
the spreadsheet and then using the free download form
However, everytime you refresh the pivot table the data labels will return
to their defaults.
This problem can be avoided by using a Pie chart. In which case ...Tables to PDF
I'm working with a table in Publisher at the moment & have formatted all my
column / row gridlines to 0.25pt. However, when I convert to Adobe PDF, some
of the lines appear much thicker than the others.
Have you tried printing the .pdf file? I've seen lines that look thicker but
print just fine.
MVP Microsoft [Publisher]
"ianp" <email@example.com> wrote in message
> Hi there,
> I'm working with a table in Publisher at...Changing individual characters in a cell to a different character
I am trying to write a bit of code that will look at a cell and covert what's in the cell to some sort of code.
Hello Goodbye Yes No
The above words are in different cells, and need converting to a different code, for example H is 1, e is 2, l is 3 and 0 is 4, so Hello would be 12334
The entries to the cells will be different, so I can't just do a select case and have Hello as one of them. Is there any way of doing a select case type statement, but for it to look at individual characters in a cell and cycle through until it's finished and then move onto the next c...How do I show summary totals from a pivot table on a bar chart
I created a pivot table which shows the both individual and grand totals
based on the fields I selected. I then created a bar chart based on this
pivot table. What I would like to do is show the grand totals as well as the
individual totals. Is this possible, if so how do I do it?
When I try this (link to the pivot table's summary total) I get an error
saying not a valid function. The function line contains
"Jon Peltier" wrote:
> Colleen -
> You can add textboxes to the chart, which are linked to works...how can i change a linked sound file to become an embedded
i am trying to package up a powerpoint presenatation that contains an audio
track - which is an mp4 file. Within the presentation the sound file is
currently a linked file. I've tried using the 'package to cd' function but
I can still not get the sound to work when i then put the cd into other
computers. so how can i embed it instead? i've tried deleting the track,
raising the 'sound size limit' to 6000 kb and resinserting it-but that
doesnt work. the file is 5.3MB.
My plan is to ultimately email the presentation - but it's vital that the
s...How to change a single page orientation in one documet?
I have one set document with 10 pages inside. But I need only two pages (i.e
page 6&7) display as landscape format. The rest let it be potrait. How to do
"Trisya247" <Trisya247@discussions.microsoft.com> wrote in message
> I have one set document with 10 pages inside. But I need only two pages
> page 6&7) display as landscape format. The rest let it be potrait. How to
Create a section break before and after each page you want to be
htt...Change FROM email
We are looking at a web fax servcie and would like to have some of our
automated emails use a common email address when sending a fax so that all go
into a common user inbox. Is that possible? Thanks.
Yes, it's possible, but the details depend on the Outlook version and
whether the common inbox is in an Exchange mailbox. You should always
include information like that when posting on an Outlook forum.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/arti...How do I stop Excel from changing simple numbers to their 1/100th.
I'm working with the latest service pack of Excel 2000.
Every number I enter into any blank cell becomes that number's 100th decimal
value. For example, typing "2" in a cell results in "0.02" when I leave the
This did not used to happen, but I don't know what I did to make it happen,
nor what to do to stop it from happening.
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals'
Chris C wrote:
> I'm working with the latest service pack of Excel 2000.
> Every number I ente...How do I change x-axis in an Excel Radar Chart?
I would like to plot a radar chart with 360 points however the excel radar
assigns a line for each point, I would like to reduce this to 1 line every 10
degrees. Is this possible?
Ideally I would like a polar plot graph where I can enter any angle and
magnitude. Does such a thing exist?
For polar plot you can use the xy scatter. I have an addin that may help.
Dr. J.White wrote:
> I would like to plot a radar chart with 360 points however the excel radar
> assigns a line for each point, I would like to reduce this...How to change from OTA to Cable Clear QAM in WMC7
When I installed my tuner, I set up Live TV for OTA DTV. Got terrible
reception, so I am trying to re-setup the live TV for digital cable clear
QAM. I can't seem to find the menu to change the way TV signals are
acquired. When I tried to change the TV signal menu, it entered the setup
process after the point that OTA DTV is selected. I really just want to
erase everything I did for live TV and start over. Is there a way to do
this, without re-installing windows?
...Changing default format for http references.
Microsoft Office Publisher 2003.
How can I set the default for http references in a publication so that it is
not a hyperlink? It is a nuisance to have every usage of http://something
converted to hyperlink format and then to have to go back through the
document and clear each one (and likely overlook several).
Try, edit, find... replace
Mary Sauer MS MVP
"James Hahn" <JamesHahn@hotmail.com> wrote in message
> Microsoft Office Publi...Sales transactions Tables activity
I have Great Plains 9.0 with Service Pack 3 and am looking for a quick
explanation on Sales Transactions table entries.
Is there any way someone can quickly go over what exactly happens on a
Sales Order during the Sales Transaction process.
From placing an order, to picking it, to fulfilling it, to invoicing
and creating a back order.
My issue is that we have moved from printing Pick Tickets at time of
order entry, to having our Warehouse print the pick tickets once an
hour. The problem is that some Pick tickets don't print, and we
cannot determine why. The reps who have entered the o...MS Access Copy record to another table based on a form input 10-08-07
I have 6 Tables, all with identical fields. I want to copy a record
from one table into another table, which table depends on what table
is selected in a form. So if the table names are One, Two, Three,
Four, Five, Six, and the record that I want to copy and insert into
another table has been selected by a query in a form. I want the form
to direct where to insert the table. So if the form has table Two
selected (from the drop down list) then it should insert the record
into table Two. If the form has table Four selected then it should
insert it into table Four. The table the record is...Using a sub procedure to change a subform property
I am currently using the following code to change the AllowEdits property on
any form. The form calls the Sub procedure through a button's OnClick event.
Sub UnlockForm(strFormName As String)
On Error GoTo Err_unlockform
If Forms(strFormName).AllowEdits = False Then
Forms(strFormName).AllowEdits = True
MsgBox "Form is now unlocked for editing."
I am trying to call this Sub procedure from a button on a subform. I was
going to us...Changing the name part of a From address in outbound emails
When emails are sent from one of our pcs, the name of the pc (APC017) is
being displayed to the email's recipient as part of the 'From:' field (ie.
the From field shows APC017<firstname.lastname@example.org>).
How do we change the APC017 part? We have changed the Display Name and other
properties but it has not made any difference. We don't want to change all of
our email addresses - just customise this specific one.
We are using Small Business Server 2003 with Exchange 2003 SP2 and Outlook
2003. Apologies if this is something really simple!
You will most l...i want to allow users to edit changes afetr password protect of c
Please use the body of the message to describe what you want.
Gord Dibben MS Excel MVP
On Wed, 19 Aug 2009 01:15:02 -0700, mamta raul <mamta
...how to change stub height on statement?
The default stub height on the statement.xml is 3 inches. I want to change
this to 3.5 inches, but when I change the StubHeight value in the xml file to
3.5, it moves the stub border down to 3.5" correctly, but messes up the rest
of the statement below the payment stub. The variable I changed must affect
other parts of the statement. How can I avoid this?
never mind, i re-printed a few times and was unable to repeat the printing
error, could have just been a fluke. on the first print after changing the
stubheight property, the account summary and account receivab...Automatic changes in cell entries
How does one shut off the abjectly rediculous habit of Excel insisting on
knowing better what I want for cell entries than I do?
EG If I type AKs I want AKs not Aks... :mad:
I have reviewed all the options in Tools|Options as well as other places to
tools-option-edit and the last item <enable autocomplete cell values>
doco <email@example.com> wrote in message
> How does one shut off the abjectly rediculous habit of Excel insisting on
> knowing better what I want for cell entries than I ...Ability to Change PO Number When Generating PO From Sales Order
When generating a Purchase Order using the SOP to POP link (from Sales
Transaction Entry) would like the ability to change the next PO Number.
...Error message with security roles changes
Thank you to mention me make copies before I change the
security roles. I tried to change the security roles in
1. Make changes to the original security roles, then save;
2. Make copies of the original security roles;
3. Make changes to the copies of the original roles, then
All come up with an error message after a long time
waiting. Can you please give me some ideas about what's
the possible cause?
By the way, in the event logs, it says that security
descriptors have been changed successfully. Also, I can
see that all the commands are excuted on SQ...am trying to make my own fun wine bottle labels
And your question is.........................?
MVP Microsoft [Publisher]
"marksbrady" <firstname.lastname@example.org> wrote in message
Go to your local office supply store and look around for an appropriate label and
design a fun label.
Mary Sauer MSFT MVP
"marksbrady" <ma...Pivot Tables
When a pivot table has 2 indices, the values of the first index ar
left blank on the 2nd and subsequent lines of the 2nd index. Can thes
index values be automatically duplicated?
Message posted from http://www.ExcelForum.com
Send me your email address and I'll PM you a small add-in
I put together to do this..
>When a pivot table has 2 indices, the values of the
first index are
>left blank on the 2nd and subsequent lines of the 2nd
index. Can these
>index values be automatically duplicated?...