XY marker change for entire workbook
Is there a way to change the markers for data series across several charts
within a workbook? I have been given A LOT of charts to make consistent and
was wondering is there is a way to apply a certain marker style to an entire
data series across several charts. Each chart is made from one data sheet in
the workbook, but placed on a separate page within the workbook.
You would need to use a macro to loop through the charts, changing the
markers. For example
Dim cht As Chart
Dim srs As Series
For Each cht In ActiveWorkbook.Charts
For Each srs In cht.Series...Settings margins for imported documents
When I import a document from Word into Publisher I find I am unable to
change the margins on the pagfes. The document has 108 pages. I have tried
to change the Master and apply it to all the pages but it just does not work.
Any help would be appreciated.
How are you importing? Best way to import text would be to create two pages in
Publisher, on the arrange menu set your margins, create a text box on each page, link
them, copy the text from Word, paste into the first page, Publisher will inquire
about creating pages, click yes...
Mary Sauer MS MVP
http://office.microsof...SBS2008 + C:\ partition very low on disk space
Been to see someone who had a very early SBS2008 to do some service packing
etc etc as they had been having some issues.
When I got there the C:\ partition which is 65GB only has 5GB free disk
space left on it..
Weird thing is when you check out how much disk space the files and folders
are using this only amounts to 27GB !
So where pray tell is the other 33GB consumed ???
I've turned off all the hidden files and folders etc etc to view this so I
should be looking at everything as far as I can tell.
Anyone any ideas ? Obviously need to sort this before I e...change password in OWA
This is a multi-part message in MIME format.
Dear all,I have a problem in the "Change Password" icon which is in the =
options page, can't work. Users can't change their password when push =
the icon. It always display " The page could not be found". I don't know =
how to change its URL to change password. Does anyone know how to solve =
this problem ?
1. Microsoft Exchange 2000
2.Microsoft Windows 2000 server
...text box on a chart can't be copied
I have a regular clustered column chart that shows compliance on turning in
Each manager is supposed to turn in 4 audit forms each month (with an
optional 5th week). Each form has 5 audits on it so that's 5 audits from each
manager each week.
I have a little chart that shows how many they turn in each week with a
horozontal line for the goal (240 for the month)
on the left side of the chart I have 5 text boxes: week 1, week 2, etc
It looks great and is easy to see at a glance who has turned in what they
should when they should.
the problem is that I copy the char...Change Appearance of Font in Email Window
I would like to change the appearance of screen fonts in the email pane in
Outlook 2003. When I open an email, there is a button on the toolbar which
allows me to increase the appearance of the font size, but is there a way to
make the larger size the default?
...Cut/Paste graphics & text from Powerpoint to Word
Operating System: Mac OS X 10.6 (Snow Leopard)
I'm using Microsoft Office 2008 on my MacBook Pro. I've been trying to cut-n-paste a drawing with text from PowerPoint directly into a Word document, but the text is always fuzzier than the same text in the rest of the Word document - probably because it always ports over as a picture. <br><br>This strikes me as crazy, given that Office is supposed to be a fully integrated app. Any suggestions on how to resolve this problem? <br><br>Bill Reckmeyer
I'm a afraid ...Copy and paste Internet information into Excel 2003
I have a database of 220 names. Each name has a hyperlink to an individual
internet page that contains each person's address, telephone number, email,
etc. Is there a way to automate clicking on the hyperlink, copying the
internet information and then pasting it into an Excel 2003 spreadsheet? I
tried recording a macro, but the paste failed. I got a run time error of
1004. Thanks very much in advance.
Sincerely, Michael Colvin
...Word Count when saving large documents
On some large documents, but not all, there is a verrrry long delay when
saving the document as it repeatedly recalculates the number of words in the
document. Is there a way to turn off the Word Count function in such
Software Support Specialist
Getting the word count is almost instantaneous - and doesn't rely on the save process for an update. If you're working over a
network, the *network* may be the cause of the poor performance.
[Microsoft MVP - Word]
"...JPGs changing color when importing/exporting
Two related questions
I have a color managed workflow, with a profiled monitor and Epson 1290
printer. I use Photoshop CS2 and Pub 2002. I prepare my images in PS and save
them as JPGs with sRGB color profiles. I am trying to create a full year
calendar in Pub on a single page with a different image for each month. I
have the dates in an excel worksheet which I insert as an object.
Q1 - When I import my images into Pub they all lack in vribrancy and
saturation. I know that I can change brightness & contrast in format picture
but a) this should be necessary & b) it doesnt get th...Copy Outgoing Messages
Is there a way built-into Exchange 2003 running on Server 2003 that a user
can be copied on all messages sent by another user? We have a manager that
wants to monitor all outgoing messages sent by certain users. Is this
Thank you in advance for any help.
Not a good way, but it's possible.
Move that certain users to a separate mailbox store and use the "Archive all
messages sent or received by mailboxes on this store" option to forward all
the message to a single mailbox of a dummy user account. Certainly NOT a
good solution if that certain users have large mai...Copy a shortcut based on group membership..
Hello, I'm new at vb scripting so forgive me the newbiequestion:
I'd like to do something as trivial as copy a shortcut to the users desktop
based on what group he's on. If he's a member of the group "students" he'll
get a my shortcut, otherwise he shouldnt. Getting the shortcut on the users
desktop isnt the problem, i just want to base it on group membership. I'm
trying to do this in my logonscript that all users run on my domain.
Anyone help me out?
You can use Group Policy Preferences item-level targeting to achieve
this, I believe.
Is there any way to put security by groups/users for specific
documents/folders in document libraries?
Windows SharePoint Services version 2.0 doesn't have the functionality to
specify item or folder level security in a document library. You can specify
security only for the entire document library.
Microsoft Dynamics GP
This posting is provided "AS IS" with no warranties, and confers no rights.
> Is there any way to put security by groups/users for specific
> documents/folders in document...MX/Smart Host/SMTP Address Space scenarios
By http://support.microsoft.com/default.aspx?scid=kb;en-us;294736, we
understand that unlike Exchange 5.5 you don't have to create SMTP connectors
unless you're interested in servicing certain conditions, such as SMTP
For the most part, we don't need anything special, we forward everything to
a smart host except for about 15 domains.
You can configure every SMTP virtual server to forward all its SMTP mail to
a smart host.
--is it correct to assume that this means for all domains except your
internal, or will it force the smart host to accept everything you&...What does fragment change mean with the words unprofessional devev
What do they mean?
fragments <email@example.com> typed:
> What do they mean?
What does "they" say?
Please write you question in the big white space and make is clear and
unambiguous. We have no idea what you are asking.
Terry Farrell - MSWord MVP
"fragments" <firstname.lastname@example.org> wrote in message
> What do they mean?
...ES55 Changing outbound delivery port from 25 to something else ?
I need to change my Exchange Server's outbound ports used by the
IMS, is this possible ? This is to reduce hop number counts, as we
have recently been getting ndr's based on our outbound hop counts..
The outbound port is negotiated with the recipient
system. Your's connects to TCP 25 and a dynamic port is
negotiated. The hop count problem isn't cured like this.
What symptoms are you experiencing re bounces?
>I need to change my Exchange Server's outbound ports
used by the
>IMS, is this possible ? This is to red...how do i change to the new design in outlook 2007
Outlook 2007 is installed on my computer but everytime I open the program the
old design is what I see.
> Outlook 2007 is installed on my computer but everytime I open the
> program the old design is what I see.
The Ribbon is only available in new message/appointment/task windows, not
to the main Outlook window.
Microsoft Outlook MVP
I am hoping someone knows a formula to help me.
I enter the info in column C each week. D is the average over 5 days,
and E is the percentage of the goal (1392/day) per week. I would
like the total at the bottom of D to automatically change without
having to go to the total of D and change the divisor. (In this example,
the divisor of the total of the numbers in D is 6. When I input the
numbers for 2/13/10, I will have to change the divisor to 7.)
After 13 weeks I will have 13 rows of data, with the average for each
column. I do this by quarter to eventually have the average...Modification dates change when moving/copying between hard-drive and flash drive
I believe that this is actually an Apple question, but I'm sure that there's
an Office user that might know the answer to it also. I use a flash drive
to store most of my work-related documents on. That way, I have them when
I'm at school (on a Windows XP computer) and at home on my Mac OS 10.3.9. I
try to occasionally back-up my flash drive by dragging it's contents to my
Mac. Copying in this direction USUALLY retains the appropriate modification
However, if I move things from the Mac to the USB drive (I occasionally make
changes to a file on the Mac when my flash...Slight change now macro error
Active Cell being A1, Date D15, Payment Received E15 , H14 Value which is
subtracted by its value to get Zero in H15
But I am getting a error now on the last line!
..Offset(14, 3) = (Date)
..Offset(14, 4).Value = "PAYMENT RECIEVED"
..Offset(14, 7).Formula = "=-" & ActiveCell.Offset(13, 6)
This was the original but wanted to change the active cell to A1 instead of
..Value = (Date)
..Offset(0, 1).Value = "PAYMENT RECIEVED"
..Offset(0, 4).Formula = "=-" & Act...change item quantity on POS
I'm just trying to change quantity of selected item on POS
I tried fallowing:
Set Entry = QSRules.Transaction.Entries(QSRules.Transaction.CurrentEntryKey)
Entry.Quantity = 5
//Not working because its only value to read
As QSRules.Transaction.Entries.Add , adding the item, I presume that there
should be something like QSRules.Transaction.Entries.SetQuantity but I can't
Would you help.
Does this help?
Always test any queries that modify data on a test database prior to running
on you...I cannot change themes because the option is grayed out.
I am trying to change my "stationery" in Outlook. I can't even get to the
option because the button for "themes" is grayed out, so I cannot select the
option. I DO have my mail format set to HTML. I upgraded from Outlook 2003.
...Extended Pricing & SOP Documents
I have a requirement to include Extended Pricing details
on Sales Orders and Invoices.
Once an Extended Price is calculated it would seem
reasonable to be able to print details of the List Price
and Discount given on the sales docs.
I would be interested to hear from anyone who has tried
to do this.
...admin /r doesn't allow heuristics change on Address Book Views
I have Exchange 5.5 w/sp4 and a problem in the permissions
of the Address Book Views container. It will not allow me
to change permissions. I am trying to remove permissions
for a group in a domain that is being decomissioned.
I found lots of KB articles about this and SP4, which lead
me to try running admin /r to set the heuristics to 1.
However, no matter which account I use I still get
permission denied even trying to set the heuristics in raw
Any help will be appreciated.
Depending on the version of DSAMain that you have (basically what is your SP level...Bill-To Addresses Saved with SOP Documents, Not from Cust Card
For SOP documents (quotes/orders particularly), would like to be able to have
document-specific Bill-To Addresses -- one-off Bill-To that would the follow
doc to history and transfer to the Invoice.
In other words, when you select a bill-to address that is pulled from the
list of the Customer's addresses, you should be able to modify that address
for that order only (without necessarily changing the the original address
from the Customer address list).
This would be useful for specific situations such: 1. a purchasing agent
placing the order wants the invoice sent to him/her dir...