using master page in publication with text boxes
When I use a master page that has text boxes in a publication, how do I get
text in the text boxes?
> When I use a master page that has text boxes in a publication, how do
> I get text in the text boxes?
Go to...View / Master Page.
Select the textbox.
Position your cursor where you want the text to begin.
These exact text boxes will appear on every page.
MS Picture It! -
Digital Image MVP
Highlights and FAQs
This is not tech sup...How to find folder tree for emails in search results?
Is there a way to see the entire hierarchy of folders for a message in
the Search Results window?
I just did a search of all mail folders (Outlook 2007). It returned
about 20 results. In the "In Folder" column, it only gives the name of
the folder the message is in, not the whole folder tree. I have a
somewhat complicated folder tree structure and I would prefer not to
have to open all of the branches looking for the correct subfolder. In
some cases, there may be more than one folder with the same name.
Not as far as I know. Search results return the item, not the tree....Destroying a Modal Dialog Box #2
SomeBody give me a solution for destroying a Modal Dialog Box created by
I have two ocx controls, switched on a single container. When a modal dialog
Box of one ocx is invoked and try to switch to other ocx from the main
Window, Previous ocx has to be destroyed and new ocx has to be created. I am
facing the trouble of not able to destroy the modal dialog box,if any,
invoked from the prevoius control. This is a common problem without any
I used the following code to destroy
pWnd = FindWindow(NULL, _T("Alert Me"));
if(pWnd->Destroy...What happened to the New Form Dialog box; are there still autoform
..."An unexpected error has occurred" emailing pub doc
I get this message when trying to email a publisher document that I've sent
...How to delete the sheet with out dialogue box
I want to delete the sheet with out dialog box. If i click
delete sheet option in my excel, One dialogue box (Data may exist in
the sheet(s) selected for deletion. To permanently delete the data
press Delete.) is opened. I dont want this dialogue box. How to
*I want delete the sheet immediately with out dialog box after
click the delete option. *
Pls help me.
ramkumar_cpt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28673
View this...Sum based on range values
I need to sum a column A, but only if values in an adjacent column B>0.
Therefore the example below should sum to 10 (only including the first 3
Ideally this should be a formula in a cell, not a macro.
Any ideas? It doesn't sound complicated, but I can't get my head round it.
Thanks Julie. I knew it had to be straightforward. Just a case of knowing
which function to use.
"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> us....NET & XSLT: Unwanted namespace in resulting file after using extension objects
after using extension objects in the stylesheets there's an additional
namespace entry in the resulting file.
How can I prevent that?
XslCompiledTransform xslt = new XslCompiledTransform();
XsltArgumentList xsltArgs = new XsltArgumentList();
xslt.Transform( _source, xsltArgs, target );
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
&l...hyperlink button on a userform
I have a userform which has a column of textboxes displaying hyperlink
addresses pulled from a vlookup table. The text boxes have the names :
I have Command buttons next to these boxes to which I would like to add code
such that they call up the web for the listed hyperlink shown in the text
Can anyone help?
"Roger on Excel" <RogeronExcel@discussions.microsoft.com> schrieb im Newsbeitrag
news:E...Find Last Row and Name the range
I'm having a problem doing something I thought was rather simple.
What I'm doing is copying a worksheet from another file which can have any
number of rows in it into the current workbook.
Once the worksheet is copied in, I want to name a range that will start on
A3:B3 and go to A?:B3.
So I need to determine the last row with data in it, and name that range
The code I have below winds up naming the range above A3:B3... So A1:B3 is
what ends up being named "Units".
Please, any help would be great. Thanks.
Dim strLastCell As ...finding a number witin a range
i have to place a unique number onto a bag. There is a start number and an
end number. The numbers are in sequence and no numbers are duplicated.
There are approx 5,000 numbers for each job. I need to know if i can find a
number witin the range and display the results.
VLOOKUP will look for a value and return a related piece of information - so
if your bag numbers are in column A and the results in column B you could
use the following formula
where the number you're looking for is entered in D1.
Hope this helps
"paul wither...test value between range, and month
I cant get the condA or condB to execute if value of A1 fall within range 1
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below
a b c 0 mth inc
2 mth inc
3 30-may-08 =text(c3,"mmm") will get
value of "may" how to get "jul"
Question1: not clear, as written you are missing the = sign in front of IF.
But there is nothing wrong with the construction. Tell us what is in A1 and
what condA, con...2007 Lifetime Planner giving wrong results
Ok, I just upgraded to 2007 and my Lifetime Planner Results (the chart)
changed dramatically from the previous chart in 2006. It went from a plan
that steadily grew, to one that initially climbs slower and then takes a
strong nosedive after retirement. In 2006 I was set for life; in 2007 I'm
in major trouble.
I've noticed several things but I think I've found the major problem.
The Planner is configured to get my Expenses total from the Budget (I stayed
with the Advanced Budget). Under 2006, that number was about $40K per year.
Under 2007 the Expenses is now $64K ($63,12...Copying list-box control
I need to copy a list box control into about five hundred
cells. I need the cell link of the control, however, to
change so that it references the cell the control is
pasted into. No matter what I do, however, the cell link
of the pasted control stays the same (not surprisingly)
as in the original control. (And nope, it doesn't seem
to matter whether the cell-link reference is absolute
[including dollar signs] or not.)
If anyone has any ideas, I'd be extremely appreciative--I
really don't want to individually format 300 controls.
What kind of listboxes are th...Edit box in a dialog box
I am trying to create an edit box inside a dialog box during runtime, using
MFC. Mine is a single document/view application.
The way I am trying to do, is as follows.
In the OnInitDialog() function of my dialog box(CmyDialog::OnInitDialog()),
I declare a CEdit object and call its Create() function.
myEdit.Create(ES_NUMBER | WS_OVERLAPPED | WS_VISIBLE, CRect(0,0,10,10),
I am expecting an edit box...Xl 2002 Combo Box Problem
I created an excel wookbook in Excel 2000 / Windows 98. When i open i
in Excel 2002 / XP, some of the Combo Boxes are flipped upside down
When you click them, they right them selves until you click off o
NYSTECH's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1457
View this thread: http://www.excelforum.com/showthread.php?threadid=26203
I've heard of this happening with pictures--never with comboboxes.
But maybe this will help:
http://support.microsoft.com/default.asp...class wizard belives group box is a button
I use MS Visual C++, Version 6.0.
Since I tried to use a component one number control (ActiveX) in my project,
which brought the whole Studio 6.0 to crash, i see a strange behaviour.
Whenever I drag and drop a group box control from the controls toolbar onto a
dialog resource and then try to define a control variable with ClassWizard,
it is handled as a button control. How can I re-teach my MSVC++ that the
group box is a static, not a button? Any help would be appreciated. How do i
get rid of the component one control icon in the control toolbar?
Where is the definition file of the stan...if the cell value exceeds the limit to have a dialog box appear
Is there a way that, if the cell value exceeds a certain limit, a dialog box
Thanks for any assistance.
Check Data Validation:
Select the cells
Allow: (check out the number options: whole number, decimal, etc)
Does that help?
> Is there a way that, if the cell value exceeds a certain limit, a dialog box
> would appear?
> Thanks for any assistance.
Here's the scenario -- on an Expense Report:
If an employee was to fill in any amount in the &...open dialogue box
Can I print the Open dialogue box? I want to take a picture of all the
listed documents in each Word folder to show the date and time they were
You can take a screen shot, and insert it as an image into a Word file.
Assuming you're using Windows with no other software hijacking the
PrintScreen key, display the Open dialog box with the information you need,
and press Alt+PrintScreen. This sends a copy of the current window to the
Then click in a blank Word document, and press Ctrl+V to paste the image
into the Word docume...range to cell
I am writing a program.
I have a excel range object.
And I want to point another cell at this range.
how can I do that?
On the range there is column = 4 row = 3.
but I cannot just say
or something like that?
don't you need
why is the column D and not 4?
> I am writing a program.
> I have a excel range object.
> And I want to point another cell at this range.
> how can I do that?
> On the ran...To have selected the year on combo box
The following crosstab query can produce the name of our church offices
sideway ( year to year comparison), but how can we make it to seledt the year
on combo, and then the report will produce it for the last 5 years: since my
landscape report can only accomodate for 5 years while my data is already 10
These is my query:
TRANSFORM First(PelayanJemaatbyYear.NamaPel) AS FirstOfNamaPel
SELECT PelayanJemaatbyYear.Nurut, PelayanJemaatbyYear.BidangPelayanan,
First(PelayanJemaatbyYear.NamaPel) AS [Total Of NamaPel]
FROM Pel...How do I set the print range on a form. Regards
I've created a Timesheet on a form in Excel, but when I print, it only prints
a third of the form
Enter this into Excel help:
Define or clear a print area on a worksheet
This should give you a solution
"Dave K" wrote:
> I've created a Timesheet on a form in Excel, but when I print, it only prints
> a third of the form
In Excel 200, you would select the are to print, go to "File", "Print area",
"Set print area".
To make it easier and quicker to print in future, you can record a macro as
you print the print area and att...lookup over multiple ranges
I want something to the effect:
but I want to do this without using an if iserror function. Is there a
way to do this? An array formula perhaps?
it is possible, if both Range1 and Range2 contain same number of rows
Define range name
Range1 = $e$5:$f$10
Range2 = $k$5:$l$10
Lookup Value placed in H5
???????:email@example.com...unintended result from holding down control key
I held down the control key for a few seconds and a dialog
box opened with an accessability feature. I
unintentionally turned the feature on and now I must wait
several seconds between repeated uses of any key. How can
I turn this annoying feature off?
Goto Control Panel and select Accessibility Options. Look
under the keyboard tab to see which options are selected
and turn them off. Probably Sticky Keys
>I held down the control key for a few seconds and a
>box opened with an accessability feature. I
>unintentionally turned the feature ...How do I name a range and then have that range be dynamic?
I want to select the entire contents of a worksheet, but that data set
will change each time I open it as records will be added to it every day.
I want to always choose all records, and there will never be any
non-contiguous rows in the data or blank rows in it.
So I can make a direct call to it and always get all of it by way of
the named range.
If A1 is the header for example for the first column you can use
The same as Ctrl *
Regards Ron de Bruin