How can I insert a cell reference in a footer (eg for variable foo #2
Any ideas on how to do this?
I'm trying to create a template with the doc reference number in the footer
However, I'm trying to avoid users having to edit the footer (because this
just wont get done).
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.PageSetup.LeftFooter = .Range("A1").Text
This code should go in the ThisWorkbook code module.
(remove nothere from the email address if mailing direct)
"wngg001" <firstname.lastname@example.org> wrote in message
news:8A0F9D9E-269F-45CF-A6E3...Test Mail...Please Ignore #2
Testing NNTP Client,
Please ignore message
...Number of active sheets
I have Office 2003 installed to Windows 2003 terminal
servers but I have a problem with on of our users and
The issue is that when the user is trying to have
multiple spreadsheets opened he keeps getting the
message "This operations has been cancelled due to system
restrictions- Contact your system Administrator"
I can find no setting in excel to enforce a limit on the
number of speadsheets a user can have open.
Thanks in advance fo any advise
Not an expert in these matters, but;
Is it possible that the user is trying to initiate another session of
Excel vs....Drop down menu #2
Is is possible when you have a drop down menu, to have excel short list the
menu as you type in more charcaters of the text. For example a have a list
of several hundred customers. I start inputting the first few letters of the
customers name, I would like that list of several hundred to be shortened to
only include thaise customers that begin with the letters I have typed in.
Think this previous post by Debra Dalgleish would be of help:
"Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can se...Upgrade from Money 2004 to Money 2005
I just upgraded from Money 2004 to Money 2005, and 2 of my accounts (a
savings account and a credit card) showed significantly different
balances from the last time I looked at them in Money 2004. It seems
that, for some reason, when it converted my 2004 file to 2005, it only
grabbed a portion of the transactions, and considered the balance as
of just before the first transaction it grabbed to be $0, when both
accounts actually had non-zero balances at that time.
Am I missing something, or is Money 2005 just that poorly designed?
In microsoft.public.money, dbrebel wrote:
>I just upgrade...Associated external Account #2
Just got some of our exch2k users migrated to another org exch2k3. Found
that associated external account rights which never seen before in 2k. Wish
to know the purpose of this account and when is the best time to use it.
Please help and thousand thanks.
Granting Access to External Accounts
"Elton Seng Yan Thung" <email@example.com> wrote in message
news:enFBAvpwFHA...virus scanning #2
I really get prompted for "requesting virus scan", and I don't know ho
to disable it; the warning is located beside ready, in Excel bar
Gerbatin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1523
View this thread: http://www.excelforum.com/showthread.php?threadid=27651
What antivirus software do you use?
I think/hope the solution will involve a setting that you can toggle in that
program. (maybe you missed an option???)
The antivirus program doesn't have t...Pivot Table fields #2
Is there a way to format multiple pivot table fields at
one time and have them refresh that way, rather than
having to select each column and choose the format
I think the solution for you is to open the Pivot Table
Toolbar and select the Field Settings icon. This sets the
format for all results for that particular field.
One limitation that I haven't found a way around is
getting a preferred column size to "stick" and not reset
after a table refresh.
>Is there a way to format multiple pivot table fields at ...Turn data #2
Is there a way to turn the data in an Excel spreadsheet so that what is on
the top is now on the side and what is on the side is now on top?
I need to export my spreadsheet into Access but, I can't get it to format
correctly in its current orientation.
~Make a backup copy of your data to work from (just in case, so you
don't lose data)
~Highlight the entire range of data; click >Edit >Copy
~Choose a new location, on a different sheet perhaps; click >Edit
>Paste Special and select the Transpose box; click OK
Does that do it for you?
thank you so much. You are a genius...2 questions about Exchange Server 2000
1. How, or where, do I find out where Service Pack level I have installed? I
see that I downloaded SP3, but I can't tell if it was ever installed.
2. Clients have Outlook 2000. Inbox is open. Last message is selected. No
new mail. Then, if you click on a different message, you get the "new mail
has arrived..." message. It seems to only deliver new mail when you change
1. In Exchange System Manager, highlight the Servers container. It should
show you all servers in the right pane along with their service pack level.
2. Sounds like something is b...Only 1 taskbar button when i open 2 excel documents
Hi all. When i open 2 excel documents i have only 1 taskbar button on the
taskbar even though i did not choose the option to group similar taskbar
buttons under taskbar properties. Hence when i want to switch between the 2
documents i need to go to window and select them. Hence how do i solve this
so that i can have 2 taskbar buttons of the excel documents on the taskbar?
Thks in advance.
Tools>Options>View, check Windows In taskbar
"inenewbl" <firstname.lastname@example.org> wrote in message
news:6F715432-2EB2-47AC-B737-56D63F37537A@mi...Business Cards #2
I am trying to create business cards using Microsoft Publisher 2002 on XP. Where would I find the template for Avery 8397, or for any of the Avery business card products.
In page setup, select business cards, click Change copies per sheet and adjust the
margins to fit your template.
Avery has blank templates for downloading, choose Cards, there will be a list to
select from. Your number was not among them but generally business cards are pretty
Mary Sauer MS MVP
http://office.mi...Can not create Matrix Item please Help RMS 2.0
Can not create Matrix Item please Help
When trying to create any new items I receive error message
This is the message
(-2147217864) Row Cannot be located for updating. Some values may have been
change since it was last read.
Manger still creates standard items but still receives message with out this
number in message -2147217864
...Macro Recorder #2
I have a very basic question( I think). When you are recording a Macro how
do you stop and then restart where you left off? For example I have a
repetitive task that moves columns from one spreadsheet to another. The
problem is that there are about 40 columns I am required to move.
As I record the macro can it be stopped and then restarted if I have to
close Excel and return later?
I can't find the answer to my question documented anywhere.
You can stop it, but when you start again it will create a new subprocedure,
you can go in and copy/paste the second after the firs...2 mirror files with :1 and :2
Not sure how, but have 1 excel file, lets call it FILEA.xls and when I open
it, it opens a FILEA:1 and a FILEA:2 workbook. Any change made to FILEA:1
gets repeated in FILEA:2 and vice versa. Looks like some sort of mirroring,
or changes being tracked, but track changes is turned off. Any help is
you've opened two windows of the same workbook (from the window /new window
menu) - just close one and then save - this should solve the problem
"DJR" <DJR@discussions.microsoft.com> wrote in message
news:F0F6BDF5-9DC2-486E-947C-ABBB6C4544...Date Range #2
Can someone please assist me with the following issue:
I am currently using the formula noted below to direct
another application ( Bloomberg ) to select prices from
the previous 6th business day.
My question is> Is there any way to revise the formula to
exclude US holidays for successive years (i.e. for 2005,
2006...) without having to manually change the date
entries each year, in the formula?
I'd recommend listing...Load Balancing 01-11-06
We are looking to load balancing the CRM application. Is there any
additional licensing required in order to do so?
Assuming you are using v3.0, you will need a server license for each of the
app servers, but there is no additional cost for user licenses.
MVP - Microsoft CRM
"Nahi" <email@example.com> wrote in message
We are looking to load balancing the CRM application. Is there any
additional licensing required in order to do so?
Yes 3.0. Thanks!
...Uninstalling Office 2003 Service Pack 2
I have installed the Service Pack 2 for Office 2003 and have decided that it
causes too many problems with Outlook 2003. For example, it sees certain
emails as "Junk Mail" and (evidently) believes them to be "phishing". Even
after placing these emails in my Inbox and adding the sender to the white
list, it refused to allow me to open links from any web page link within the
I understand that I cannot simply uninstall Service Pack 2, that I must
install Office 2003 and then reinstall, without, of course, reinstalling the
Service Pack. But if I do that, I wonder...Comparing Worksheets #2
I have 2 worksheets that should be identical. One I know
has been changed. Is there any way to compare the 2 to
One way is to use a third sheet. In A1 type
This will return TRUE or FALSE. Fill this across and down as many as you
"Darryll" <Darryll_lamb@hotmail.com> wrote in message
> I have 2 worksheets that should be identical. One I know
> has been changed. Is there any way to compare the 2 to
> track changes.
Thanks for your help Andy. All seems ok.
I have an xls sheet that always print 6 copies. When ever I want to print,
I have to change it to 1 copy. It's only this one xls sheet. Everything
else prints 1 copy like it's suppose to. It's not the printer settings.
Like I said, it's just this one xls sheet. Can someone tell me how to make
it print 1 copy only and then stay as 1 as the defualt. I have made many
changes to the sheet and saved it many times, but it always defaults to 6
Thanks in advance.
If maybe as simple as this, as each page can have the page count se
individua...Money 2004 crash on startup #2
just find that it only crash when i use my current user, not happening when
i logon as another user, seems my profile has some problem, maybe more
startup & program installed. any idea on how to troubleshoot ?
just install in my WinXP SP1, which has IE6.0 SP1 installed already.
Money2004 Std keep crashing on startup after install.
with error dialog of "restart Money - Send / don't send report"
any idea ?
a further findings, i run Money2004 using "run as" another user, it works !
using local adm or domain userwith local adm right also run correctly....how do I create a spread sheet to automatically calculate when I
On a new spread sheet I am entering numbers and I would like them to be
multiplied and changed automatically. The formula is x*3 then less 40%.
Can anyone help me.
If you are entering your numbers in column A, say, then in column B
copy B1 down as far as necessary.
In article <678FA28E-14A7-40E5-B0DF-54D574F9F7E3@microsoft.com>,
wbinfo <firstname.lastname@example.org> wrote:
> On a new spread sheet I am entering numbers and I would like them to be
> multiplied and changed automatically. The f...Change print driver from PS level 1 to level 2
When printing in Publisher 2003 only, on and HP business inkjet 1100 I'm told
that I need to set the PostScript language level to level 2 or higher.
Following the instructions, I can't make the changes as directed in
corrections from the error message, nor can I find any other way to change
You receive a Publisher cannot print this publication error message when you print as
CMYK composite in Publisher 2003
Mary Sauer MSFT MVP
news://msnews.microsoft.co...outlook won't connect to server #2
I have just installed Outlook 2003.
I haven't used Outlook before.
I have a Hotmail plus account.
I have set up outlook to use this Hotmail account, but I cannot connect to
the server to do so.
I am fully connected to the internet when I try, through my ADSL broadband
hoo22 <email@example.com> wrote:
> I have just installed Outlook 2003.
> I haven't used Outlook before.
> I have a Hotmail plus account.
> I have set up outlook to use this Hotmail account, but I cannot
> connect to the server to do so.
> I am fully connected to the...gridlines print over text #2
When printing an Excel document with gridlines, some of them print over the
text, and they don't line up properly. I've checked my text and spacing
settings, and everything seems fine. Am I missing something?
It sounds like the rows and/or columns are not big enough for the data - you
could try the Autofit option
> When printing an Excel document with gridlines, some of them print over the
> text, and they don't line up properly. I've checked my text and spacing
> settings, and everything seems fine. Am I missing something?