You people have been so much help to me and others on this board. I reall
appreciate all of the good information that is given here
Someone listed how to put check marks in cells by using the righ
click method on the mouse - works great! But the code is for a range of columns
I want to select just 2 columns (column 2 and 14) to put the check mark in
Thanks again - you people are great!
if you may post your existing code it should be quite straight-forward
to restrict it on only some columns :-)
> You people have been...Main Switchboard displayed not same as one in Switchboard Manager
I just upgraded my Access database to Access 2007. When I go to the
Switchboard manager it is not the same as the Main swtichboard that is
displayed in my Forms.
Do I need to delete the switchboard and recreate it again?
Why is it picking up another switchboard?
...Moving .pst from one drive to another in Outlook 2003
Is it possible for me to move my .pst file from my C: drive to my E: drive
(Outlook 2003 only) ?
I've found knowledgebase articles that apply to Outlook 2002 and 2007, but
those processes don't work. I get hung up when I try to delete the old one
and it tells me to go to Tools/Options e-mail account to change the default
location of delivered mail. I can't find any place to do that.
If you have the process for Outlook 2003 (or a KB article), I'd appreciate
"Gregg Cattanach" <firstname.lastname@example.org> wrote in message
news:%23usD2pp%23...Excel shows only one sheet in taskbar
When I open an excel worksheet it displays in the taskbar but when I open
subsequent sheets they are not displayed in the taskbar.It looks as if only
one document is open. This is very annoying as I am unable to close a
certain worksheet from the taskbar.
On Fri, 9 Jan 2004 08:55:47 +0200, "Leon" <email@example.com> - in a
blinding flash of brilliance - wrote:
>When I open an excel worksheet it displays in the taskbar but when I open
>subsequent sheets they are not displayed in the taskbar.It looks as if only
>one document is open. This is very ...emails in One Inbox
Greetings to all, and I am new to this.
I am tired of searching for my emails in various accounts.
Is there a way of merging all the folder, i.e. all Inboxes, All Sent messages,
All Drafts etc...?
Is there a rule I cna create that will do this?
I am using a Gmail IMAP account and a .ME IMAP account.
Thank you for the help in advance.
Message posted via http://www.mackb.com
On 2/26/10 8:46 PM, mokuti via MacKB.com wrote:
> Is there a rule I cna create that will do this?
> I am using a Gmail IMAP account and a .ME IMAP account.
Custom View -...Sliders with more than one variable
Hello everyone. I'm a junior in college and I'm taking an ops class. My
teacher showed us how to make sliders, but I have a question on them.
Can you make a slider change 3 variables? I'm trying to do weighted
moving average forecasting and am curious howt0 a) make 3 variables = 1
(.6+.3+.1 etc.) or make the slider give more weight to the left side as
you scroll etc.
Any takers on helping me out?
E mail me or post here. Thanx!
Bhaltair's Profile: http://www.excelforum.com/member.php?action=...Combining chart in one sheet
How can I put 2 or more graphs into one chart sheet?
Here's a link to some info that might help:
For Excel tips, macros, & downloads...
"Angel Agosto" <firstname.lastname@example.org> wrote in message
> How can I put 2 or more graphs into one chart sheet?
...Is there a way to limit access to a page in Excel to one person?
Is there a way to limit who has access to a page created in Excel to only the
people who need to have the access? Like perhaps to put a block on it?? Or
fix it so that you have to have a password to gain access to the particular
Any help would be greatly appreciated.
What do you consider as a "page"?
What is printed out is usually referred to as a page or pages.
Perhaps you are referring to a particular worksheet.
If a worksheet, you could hide the sheet under Format>Hide>Sheet then Protect
the Workbook under Tools>Protection>Protect Workbook and enter a ...how do I make a graph with one very large piece of data
I am trying to make a graph in Excel with mostly small numbers for data, but
with one large number. The graph does not display well. Is there a way to
break up that large number so that the small numbers show up too.
There is no really "good" way
Some suggestions are
1) Put football on a secondary axis
2) Use a log scale
3) Set the maximum y scale value to a small number (5, say) and add a text
box to state that football is 59
I favour #3
Bernard V Liengme
remove caps from email
"...Please recommend one freeware to prevent USB flash disk from virus
Sometimes, I plug USB flash disk into various unknown computers. And I don't
know if these computers are free from virus or not. What can I do?
On Mar 29, 7:18=A0am, "=C0=EE" <H> wrote:
> Sometimes, I plug USB flash disk into various unknown computers. And I do=
> know if these computers are free from virus or not. What can I do?
If your flash disk is a U3 compatible drive, you can get a U3 anti-
If not, there is no utility to prevent a virus from "infecting" any
flash drive. The only thing you can do is to routinely...ActiveSync Two Outlooks into One PDA
I have a Compaq IPAQ 3955, and I am currently syncing to
my WIN98/Outlook 2000 laptop at home. I need to be able
to create another sync "file" so that I can sync my
Outlook contacts from my work computer (WINXP/Outlook XP)
into my same IPAQ. I need to be able to keep the
contacts, appointments, etc. separate from each other
between the computers (otherwise, my personal information
at home will be sync'd into my work computer, and I don't
want that to happen), that is why I want two folders set
up on the IPAQ, and the ability to sync them separate from
...Changing Content in one coulumn using given content in another
I have a small puzzle.
In one column , I have a list of various components , many of which
appear multiple times. In another , I have a list of their prices.
I need a small routine which will ask via popup for the column and
identify a particular component in it.
Then a new price for the chosen components will be requested and each
changed accordingly in the second column.
For example ;
After ( component a is chosen , new price is 4.85)
...Import One Page Into Anoter Document
I found this question posted, but there were no answers. Mary Sauer evidently
gave the answer, but I can't find the post. So sorry. I would like to create
single pages, then compile the pages of choice into one document. I'm
creating tutorials, and it is just easier to create one page at a time and
decide on page order later.
Thank you for your anticipated help. Since I am brand new here, and don't
want to miss the answer, is it possible for me to receive an email?
lsgal mary wrote:
> I found this question posted, but there were no answers. Mary Sauer evidently
...How can I merge 2 documents into one and combine changes?
I have 2 documents. About 75% of the information is identical in both. when
I merge them I get a 3rd document that highlights and red-lines changes and
shows what has been DELETED. What I want to do is:
1. Have word compare the 2 and delete only duplicate entries
2. Insert additions in one document from other
3. Show me what has been changed
4. Allow me to merge the two and ELIMINATE the correction notations (red
text, lines, etc.)
...More than one snapshot per email
Anyone able to steer me towards attaching more than one report to an
email in Access 97 (using a macro)?
I'm trying to streamline our process here, which currently involves
printing two reports, then scanning them into an imaging database,
then emailing that scanned file to its recipient. Instead of that, I
want to just have it automatically attach it to an email (like with
SendObject), but I don't know how to automate that with just one email
instead of two.
Eric D. Braden wrote:
> Anyone able to steer me towards attaching more than one report to an
> email in Access 97 (usi...create one local profile
I want to create only one local profile on a PC and and I want prevent
domain accounts to create a local profile when they will login on this
Is it a way to configure it?
Strange - someone by the name of "Haydar" posted an identical question
exactly ten minutes ago . . .
"Imad" <email@example.com> wrote in message
> I want to create only one local profile on a PC and and I want prevent
> domain accounts to cre...I have 2 accounts with the same bank... only one of them updates
I've got 2 CapitalOne cards, one a visa, the other Master Card and whatever
account I enter in first is the only one that will update. They both update
just fine on their own as I've tried them both alone. I was just wondering if
anyone has found the way to make them both work at the same time?
...How to email just one worksheet in a workbook?
I have a workbook with many sheets. I want to send just one of the
worksheets to someone.
Do I have to create special workbook and copy the sheet I want to send to
Thanks for your help.
You'd need VBA if you don't want to make a one sheet workbook
"John L" <firstname.lastname@example.org> wrote in message
> I have a workbook with many sheets. I want to send just one of the
> worksheets to someone.
> Do I have to create special workbook and copy the sheet ...Need help: table with all locations AND just one location
WHAT I WANT TO DO:
I'm trying to build a report that will summarize quarterly data for
each of my company's locations and display it along side aggregate
I built a table with five columns (item, all count, all %, location
count, location %), but I can only get it to display the location
count and % in both sets of columns.
MY LEVEL OF EXPERIENCE:
I've never used the reporting function before and I'm finding both my
Missing Manual and usual on-line resources (Lynda.com, microsoft.com)
to be pretty thin on anything beyond the mo...ONE PAGE REPORT WANTS TO PRINT 1311 pages in each copy, WHY?
The excel report is only one page but recognizes it as 1311 pages long, why.
Nothing shows on pages other than page one.
Re-set your print area.
"G'pa Woody" <G'pa Woody@discussions.microsoft.com> wrote in message
> The excel report is only one page but recognizes it as 1311 pages long,
> Nothing shows on pages other than page one.
Check your print range settings.
Clear it first then reset to your desired r...Copy Cell Formulal, but need one of the Cells to stay Static.
I am copying a formula from one cell to the next. Here is the formula:
When I paste it to the next cell below it looks like this:
When I paste the formula to the cell below, I need the C5 to stay the same,
so it sould say:
What is the syntax to do this?
Scott Buerkley wrote:
> I am copying a formula from one cell to the next. Here is the
> formula: =SUM(B5,C5)
> When I paste it to the next cell below it looks like this:
> When I paste the formula to the cell below, I need the C5 to stay the
..."one or more of the selected senders could not be added to your blocked senders list"
Hey all. I get this when ever I try to killfile anyone at all, regardless of
who they are. I'm on OE6 in XP Home and this has only just started
happening. My KF only has a few spammers in it so I don't think it's full.
Does anyone know what's going on?
"Ayatollah of rock 'n' roller" <email@example.com> wrote in message
> Hey all. I get this when ever I try to killfile anyone at all, regardless of
> who they are. I'm on OE6 in XP Home and this has only just started
> happen...How to make many random test outcomes in one chart?
From column A1 to A20 I assign 20 random numbers (A1=rand(), A2=rand(),
Then I put B1=sum(A1,A2,...,A20)
Every time I press "F9", I got a outcome of B1
Now I want to get the outcome 1000 times, and assign the data to other
columns such as C11 to C10000. How to do that?
vegas's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25091
View this thread: http://www.excelforum.com/showthread.php?threadid=386025
Here's one way....
Extend ...how to subtract one row from the other?
how to subtract one row from the other?
Use a simple formula like
Copy this formula to the right as far as you need to go.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"prasad" <firstname.lastname@example.org> wrote in message
> how to subtract one row from the other?
...Messages Dissapear for One Specific Sender
I am using Outlook 2003 on a XP machine. I have a number
of different folders created (with rules) that allow mail
to be sent to the appropriate folders. All the folders and
mail delivery work fine, with the exception of one
folder/user. I have a folder that the mail from this
particular sender should be directed to, but the mail
doesn't show up there. It doesn't show in the inbox
either. When the user sends me a message, it flashes upon
the screen and then disappears. Any idea what is going on
Is it safe to assume you've already deleted and recreate...