Can I change the default syle for a chart?
I have toyed around with using macros to reformat data, but what I would
really like to do is make a particular format the default, but can't seem to
find out how to do that.
Select a chart in your workbook
Choose Chart>Chart Type
Select one of the chart types and subtypes, then click
'Set as default chart'
Select the Custom Types tab, and set one of the built-in or
user-defined charts as the default
Jon Peltier has information on custom chart types on his web site:
Argus Finch wrote:
> I hav...Find and Replace Permissions change on Public Folders
OK, I've been tasked with changing permissions on Hundreds of public
We are bringing up a thousand new security groups in a new naming
convention, they are going to replace Mail enabled security groups
currently assigned to public folders.
How can I simplify this process? Is there a tool that performs a
function like "subinACL" that will perform a Find/Replace on public
pfDavadmin might be able to help you out. It can export permissions and you
can modify the permissions file and then import them back.
> OK, I'...How do I change line spaces in an envelope on word
I have tried Jay's solution but it doesn't work for me. I must have an
earlier version of Word. I have managed to change line spaces in a document
but when I try to create an address on a label or Envelope it prints in
Envelope addresses are formatted with the envelope address paragraph style -
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http:...Font color changed
Font color changed to black when using save as PDF function in Publisher
2007, no matter what color I used in text box. Any idea? thanks
Are you getting colors anywhere in the pdf file?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"JALU" <JALU@discussions.microsoft.com> wrote in message
> Font color changed to black when using save as PDF function in Publisher
> 2007, no matter what color I used in text box. Any idea? thanks
Only TEXT are co...Change unit cost for Miscellaneous Items
Dynamics GP Sales Order Processing does not allow editing of unit cost for
all item types. Please include an option to allow us to change the unit cost
for for miscellaneous, service and flat fee items.
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.micro...Adding a changing number of cells.
I am trying to add up part of a row of numbers. The number of cells in the
row that I am trying to add will change depending on a variable in another
cell. For instance, if there are numbers in the range a1:t1, I am trying to
obtain the sum of the range that will always start with cell a1 and end with
?1 where "?" corresponds to a number in cell b1. The number in b1 is a
variable and will change occasionaly based on other conditions. So if the
number in cell b1 is "6" I would want the sum of a1:f1.
Does anyone have a suggestion?
=SUM(...Change one page in publication to landscape orientation
I'm trying to change one page in a multi-page publication to landscape.
However, I want the others to remain as portrait orientation. Is this
possible? I can't find anything in online Help or on the MS Office website.
As a temporary work around, I have just turned the text on the page to look
like landscape orienation.
DS <DS@discussions.microsoft.com> was very recently heard to utter:
> I'm trying to change one page in a multi-page publication to
> landscape. However, I want the others to remain as portrait
> orientation. Is this possible? I can't find a...change histroy printing
I was wondering if there's any way to print out the change
history that was made to a spreadsheet showing the user,
date, time and what the changes were.
...Change a cell's value using a button
Hi - I know its possible but have no idea how to do it - How do I set up a
cell with two buttons attached to it that increase and decrease the value in
the cell? I.e. if I have a cell with 10% in it and hit the "up" button, the
number goes up by 0.5% and down by the same amount if I hit the "down" button?
I am pretty good in Excel but dont know anything about macros - but Im
really not sure where you find this function. Thanks for your help in advance
No macros required. Use a spin button control rather than
2 buttons. Follow these steps:
1. Go to...Date when I last change cell in a row?
In my database, every row represents a separate client. I wonder if it is
possible to input the date when I last changed any value in a particular row.
This way I will know when exactly I last updated the information for client
in row 4, 5 etc.
I don't need the date when the document was last saved.
Please, let me know if it can be done in Excel.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If .Row = 5 Then
Me.Range("H1").Value = Date
...Change all Chart Legend FONT sizes across entire spreadsheet
Have file folders with dozens of spreadsheets and noticed the CHART
LEGEND fonts a too BIG. I'd like to change ALL chart legend font sizes
on all worksheets in a spreadsheet at once.. using a tool or script,
etc. Any solutions? There are simply too many charts to open and
change fonts individually.
The following code will change the font size in all charts in the active
Dim chObj As ChartObject
Dim ws As Worksheet
Dim ch As Chart
Dim lFont As Long
lFont = 6 'set the font size
For Each ws In ThisWorkbook.Works...Change Display Units property with VBA
I would like to dynamically change the units on my graph within my
powerpoint presentation using VBA. The Powerpoint group has site has
been down for a couple of days so I have not been able to send my
question in. I would think the code might be similar to that in excel
so I'm hoping someone can help me here.
Can someone help some code that allows me to change the "Display Units"
property found under the "Format Axis --> Scale" menu in the graphs?
In article <firstname.lastname@example.org>,
Hi, I'm about to sell my Dell pc on which I recently installed Microsoft Home
& Student 2007. Do I just un-install it and then re-install it on the new
one? Is it illegal (or stupid) to leave it on the computer? And how would I
go about moving my Word files from old to new? Any advice much appreciated.
If you leave it installed, you must also give them the disks. (And yes, that
would be stupid - sorry.) If you intend to keep the disks and the license
for yourself, you must uninstall it.
Move your files with a USB drive or burn them to a CD. You could...How do I change a data label on an xy scatter to a unique name as.
The only way I have figured out is to create a separate series for each data
point, which is tedious for 100+ points...any ideas?
Try one of these free addin to link cells to data labels.
This way you can have a single data series rather than multiples.
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com
> The only way I have figured out is to create a separate series for each data
> point, which is tedious for 100+ points...any ideas?
Andy Pope, Microsoft MVP - Excel
http://www.andyp...Add item using HTML Status Bar
I want to add a bunch of pictures of items to the HTML status bar and have
the item added to the transaction when the cashier clicks on the item.
Is that possible? I have the customization guide, I can modify the
status.htm file to display the pictures, but I just need the code to add to
the HTML file to trigger the adding of the item (again, if possible).
P.S. I don't want to use the custom POS buttons (I already know how to add
items that way).
I almost have it figured out. I added this code to the Status.htm file:
qsBridge.FireEvent("PerformAddItem...Change 'Active' Window?
I would like to change the 'active' window (from the Access DB to another
application). I have Dynamics GP open and am currently using an Access DB.
I would like to change the active window to GP and run a macro (if possible).
Would I do this with a shell command?
Any help that you can provide is welcome. Thanks.
...color transition (color changes from dark color to light color)
How Can I change background color from one color to the transition of this
color ie. from dark color to light color?
Set the background to the first color. Put your text or pictures on the
slide. Copy the slide and past it next in the presentation. Now go to the new
slide you just duplicated. Format the background to the new color. Set the
slide transition to Fade. Now hen you click to transition the slide, the
color will fade from one to the other while your text and pictures remain the
same. It will look like the background simply changed colors.
"color transition&q...Dynamicly change spreadsheet tab names depending on cell value
Is it possible to change tab names dynamicaly ? For example i have 31 tab (1
for each day of the month)
These tabs are named - 1,2,3 e.t.c
Is it possible to define rule that would ad "!" to day which is weekend day.
In other words is it possible to dynamicly change tab name depending from
value of cell ?
If this is possbile how do i do this ?
Right-click on the spreadsheet tab, select View Code and paste this in:-
Private Sub Worksheet_Activate()
ActiveSheet.Name = Range("A1").Value
To test this I put the date in cell B2 and this formula into A1:-
=TEX...Changing the 'Mark item as read when selection changes' at runtime
Outlook version 2007
Using VSTO and Redemption
I need to change the following settings at runtime
Mark items as read when viewed in the Reading Pane
Wait [ ] seconds before marking the item as read.
Mark item as read when selection changes.
All the above settings are on a form found here:
Tools --> Options --> Other --> Reading Pane
The registry settings are stored in
I know how to change the registry settings but I don't know to re-load these
settings again without ...Business unit change?
How can I change business unit of a user? It seems that business unit of a
user cannot be changed.
If you go to the list view of users and select a user (ie they are
highlighted in dark blue) you can select "Change Business Unit..."
from the Actions menu.
If you have a user record open you can go to the Actions Menu and
"Change Business Unit..."
Note that it may be necessary for you to re-allocate a role to the
user once they have changed business unit.
It WILL be necassary to a...Change Collation failed in RMS Headquarters
I need change collation from default to Chinese. A blank database is created
in Headquarters Administrator and then Change Collation command is executed.
Error “object CK_APIExportLog_ObjectType depend on collation” happened.
How can I do it?
> Error “object CK_APIExportLog_ObjectType depend on collation” happened.
> How can I do it?
Remove from your database the constraint CK_APIExportLog_ObjectType, and
when you changed collation add it the constraint.
Thanks for your reply. Now I removed CK_APIExportLog_ObjectType and changed
co...To change the tab color in forms
I am new to the CRM version 3.0
i want to change the background color of tab & text color also
AFAIK there is no supported way to do this.
This message sent from Windows Vista!
"mady" <email@example.com> wrote in message
>I am new to the CRM version 3.0
> i want to change the background color of tab & text color also
....but there's a couple of unsupported ways.
You can apply the style you want in the onload event.
The tab id's are numbered from zero to 7: tab0Tab...copy web shortcut to outlook bar
Can't open this item. An OLE registration error occurred.
The program is not correctly installed. Run Setup again
for the program.
...change color in many text box
I have a form which takes information from a query.
The information is orizontally aranged in the many text boxes .
I would like to know how can i change the background color of the text box
on the row by just doubleclicking on that particular row.
Give me some suggestions please!
"florin" <firstname.lastname@example.org> wrote in message
>I have a form which takes information from a query.
> The information is orizontally aranged in the many text boxes .
> I would like to know how can i change the background colo...How to change a excel document into a word document?
is it possible to convert and excel document into an word document
Copy and paste?
You can actually open a .xls file in MSWord.
But before you do this, copy the .xls file to a new name and open that new
If you save the .xls file inside MSWord, you can destroy all your work (and if
you have MSWord's autosave turned on, you may not notice it until it's too
> is it possible to convert and excel document into an word document