VBA for chart title issue
I have the following macro to modify a chart title if "mypattern" is changed.
I'm having one problem though. At the place where I have vbnewline in the
mypattern code, it appears that it's displaying 2 line breaks. How do I fix
Public Sub SetChartTitle(WS As Worksheet, mypattern As String)
Dim objCht As ChartObject
mypattern = WS.Name & vbNewLine & "Division Target " & mypattern & " Days"
For Each objCht In WS.ChartObjects
.Chart.ChartTitle.Text = mypattern
Next objC...new users don't show up in GAL
When we create a new user the user doesn't show up in the
Global Address List. Any suggestions?
Troubleshoot the Recipient Update Service. You will likely see that the
accounts aren't getting e-mail addresses automatically.
I would start by rebooting and then see if you get events for MSExchangeAL.
If not look at the RUS objects and make sure they point to valid servers.
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of incl...show sum of selected cells
what function do i need to enable to allow the sum of selected cells to
show on the bottom right of the worksheet
View, Status Bar
> what function do i need to enable to allow the sum of selected cells to
> show on the bottom right of the worksheet
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=487537
After status bar is visible, right-click on it; choose desi...How can I chart a data series without showing empty cells?
I have several data series with values for each day of the week. Some weeks
there will be a value for Saturday in some of the data series, while other
Saturday cells will remain empty. How can I chart these series and not show
gaps for the empty cells?
If it is a Line chart, try:
Replace the empty cell with =NA()
With chart select, use Options|Chart and specify what you want for "plot
For Column chart: use Chart Option (right click chart to open a menu), on
Axis tab set to Category rather than Auto or Time Series
Bernard V Liengme
www....... I would like the Worksheet Tab Title to be in Cell A1 too...
Is there a function that links the text on the Worksheet Tab to a Cell?
"Dr. Darrell" <DrDarrell@discussions.microsoft.com> wrote in message
> Is there a function that links the text on the Worksheet Tab to a Cell?
This seems to be a method to extract text from a string in a given cell. I
don't think it will work with the TAB. (unless the Tab has a...appointment details show up when others request meeting
When I use the meeting request feature (Ctrl-Shift-Q), I see a graphic
display of my calendar and the calendars of other attendees. For some
attendees, I see only blue bars for their appointments... for other
attendees, I apparently have permission to see the subject of the
appointment as well, written on each blue bar.
At the moment, this is apparently turned on for all who view *MY*
calendar in this manner. How can I turn this off?
...Macro in Excel to copy paste data into multiple slides in powerpoint
I need to copy individual cell values (numbers) from Excel and paste
them on different position on a specified position on a powerpoint
slide. I need the macro to repeat the same for multiple slides by
creating a slide identical to the first one and then replacing the
Any help will be great!
Thank you for your time,
...Title of CPropertyPage
I tried to set the title of a PropertyPage using the SetWindowText function
but this doesn't seem to work. Is there another way to do this?
"Marco Jonker" <firstname.lastname@example.org> wrote in message
> I tried to set the title of a PropertyPage using the SetWindowText
> but this doesn't seem to work. Is there another way to do this?
Although it's not entirely clear what you expect, I think you'll probably
want to consult this document...
http://support.microsoft.co...Messages showing up as enclosures?
When I send messages from my office email (Outlook 2000, Exchange 2000)
to 2 specific people, my messages show up as an enclosure or an attachment
to a message. Any attachments I had sent are gone. When I send that same
message to others, including my personal email address, they are fine. They
both use Outlook, one uses 2000, not sure about the other. Also, if I paste
a table from Word into the email, they see a string of text, the table is
Any suggestions as to what I can look for to fix this?
...Money 2006 Upgrade
After upgrading to Mny 2006 (from 2005), updated bank transactions are no
longer appearing in my statements (although the update message indicates all
calls were successful). Can anyone help?
In microsoft.public.money, MFret wrote:
>After upgrading to Mny 2006 (from 2005), updated bank transactions are no
>longer appearing in my statements (although the update message indicates all
>calls were successful). Can anyone help?
In Internet Explorer, I would delete your browser temporary files
Then in Money do File->RepairMoneyFil...Chart Title with Formula
I have created a chart title, whcih I want to automate
with the following formula:
=IF(ISBLANK(A1),A2&" charges to "&A3&" compared to rates
surveyed in "&D1&" including delivery and
collection",A2&" charges to "&A1&" compared to rates
surveyed in "&D1&" including delivery and collection")
Everything comes through perfectly from the corresponding
worksheet apart from the date (being D1), which is shown
This should read July 2004 (cell formatted to mmmm yyyy,
which is pulled th...OWA Password page not showing up.
I installed the hotfix from kb 833734. I've also tried to follow the steps
found at kb 327843.
However, when I set an account to "change password at next logon" and go to
that account in OWA on a FE that's using forms based auth, it doesn't
redirect to the page for changing an expired password. However if i direct
my browser to that page manually and fill in the form, it unexpires my
password just fine.
Is this how it's supposed to work? Shouldn't it detect that it's expired and
thus redirect me to the page for resetting my password?
This ...How to Customize Business Portal to show custom objects?
I need to Customize Business Portal to show my custom objects in "Primary
Publishing List ResultViewer Web Part","Rich List ResultViewer Web
Part","Form ResultViewer Web Part"?
I need to create pages similar to Customer Summary page in sales center with
my custom objects. How can i do that?
...Contacts main title bar grayed out?
Greetings..here is a screen cap:
http://www.alanreeves.com/bohler.jpg (no idea why there are two side by
side, but ignore that)
If you look at the main line for each contact, you see there is no main
"title" for the contacts.
What happened was this: a client using Outlook 2000 hit the 2gb limit,
and the pst file was corrupted. Used the MS pst file compaction
utility to shave some data off, but there was still some corruption
apparently. Upgraded to Outlook 2003 to at least be able to get to the
data, but there were no Contacts nor Calendar.
Did a one-way sync from her Treo, wh...Chart Title
I have built a successful chart based on a query. In the query, the use is
prompted to enter an employee name and then the data is gathered based on
ONLY this employee. However, I would LIKE this employee name to appear in
the TITLE of the chart. I cannot figure out HOW to do this. I am NOT
experienced in SQL language, so please be kind. Please help.
On Fri, 9 Nov 2007 14:27:01 -0800, Steve Y wrote:
> I have built a successful chart based on a query. In the query, the use is
> prompted to enter an employee name and then the data is gathered based on
> ONLY this employe...OWA does not show e-mail
i am having an issue with sbs 2003. when a user trys to
connect to the owa via ie 6.0 it will display the mail
tree to the left, but the right pain only shows the
word "loading". i have check may of the kb articles,
nothing seams to work. i believe it is a permissons
issue with iis. i might ad that this server was
installed early november, and we reconfigured iis and set
up ftp (after 11/24/03 when the date issue for ms sbs).
things seemed to go bad after this. any ideas would be a
great assistance. i have 4 other clients configured the
exact same way without this is...Outline View's limited column width
This appears like a big lack of forethought. Word's Outline View is touted as
ideal view for laying out thoughts for a document, but the usable column
width is only about 6.5 inches. My usable screen width four times that at
about 24" wide. What a waste. Usint higher outline levels strings out the
'body text' paragraphs vertically in a very impractical way. It makes the the
column is so narrow as to be almost useless ~ only three or four words wide.
I have found no way of changing the column width! Neither page width or page
orientation helps this. Any suggestion...Month in title of monthly report
I am new to Access and have been trying to get the month name show up in the
title of a report. I am using a form for the input of the [Month] and [Year]
as numbers. Then use the form control button to execute a report. This
works great. I then would like to use the input from the form [Month] to put
the name of the month in the title of the report. I put in a text box and
can get it to display the number of the month (ex. 5) but not the name of the
month name (Ex. May). I do not know how to format it to mmmm. I tried an
rmonth = Array(“January”, “Feb...Full path in Active Title Bar
Is there a way to cause EXCEL
Here's a link that describes one way:
John Coffey wrote:
> Is there a way to cause EXCEL
...How do I show the whole chart?
All of my values in my graph are negative, so my chart only shows the 3rd
quadrant, but I'd like to make my graph show all four quadrants. Any
Format Axis/ Scale
"TuttiFlutieOboist" <TuttiFlutieOboist@discussions.microsoft.com> wrote in
> All of my values in my graph are negative, so my chart only shows the 3rd
> quadrant, but I'd like to make my graph show all four quadrants. Any
...Show plus sign in form
Hi. I am trying to create a form containing a parent / child relationship. I
would like the form contain 2 subforms in datasheet view (the parent table -
POSITION - and the child table - CANDIDATE -). This is not a problem. The
problem I am having is that I would like the tables to have the plus / minus
sign displayed as they do in the table. How can I get the plus / minus sign
to be displayed in the form?
Message posted via AccessMonster.com
For what purpose?
You're describing a "how&qu...Show and edit link table data using checkboxes
I have a form showing data on a given record. Each record is
potentially linked to zero or more values in a lookup table. I'd like
to be able to display the data in the link table by using checkboxes
to show if a link exists and to create/delete records in the link
table when the values of the checkboxes are changed.
On Oct 2, 10:41 am, Dan Neely <dan.ne...@gmail.com> wrote:
> I have a form showing data on a given record. Each record is
> potentially linked to zero or more values in a lookup table. I'd like
> to be able to display the data in the link table by usin...Using powerpoint slide master
I want to create some invitations using the same
background as my slide presentation. I am using slide
master fireball in powerpoint. I cannot copy this master
or find it to create it in publisher. Can anyone help?
Just guessing cause I don't create with PowerPoint much...
Maybe have the background open and full screen in PowerPoint.
Hit the "print screen" button.
Paste into your favorite graphics program for saving and using in Pub,
or paste directly into Publisher?
But I may be wrong :)
Steve in NC
> I want to create some invitat...Title Bar Caption in Excel #2
I want to change the caption in the Title Bar of Excel,
does anyone know how to do this, or even if it's possible?
Any suggestions would be great.
...How to show all room resources Outlook 2007
I currently have an Exchange 2003 Environment with Outlook 2007 clients. We
have several accounts setup as resources and the auto accept agent enabled
and accounts are configured as resources. We have about a dozen configured.
In Outlook 2007, when I select CALENDAR, and then, PLAN A MEETING, I want all
users to be able to see all the room resources once they open up the PLAN A
MEETING window. Currently you would have to schedule a meeting, then at the
bottom select the RESOURCES button to add the resource to the PLAN A MEETING
window. I want all users to be able to see ALL the r...