Go to section of all worksheets
I have set the following macro to unhide column Y in all sheets.
Dim sh As Worksheet
For Each sh In Sheets(Array("sheet1", "sheet2", "sheet3"))
sh.Columns("X:Z").EntireColumn.Hidden = False
However, how do I also get it to select sell H7 and also scroll to the
top left of the workbook in all sheets?
Dim sh As Worksheet
Application.ScreenUpdating = False
For Each sh In Sheets(Array("sheet1", "sheet2", "sheet3"))
With ...How do I create a trifold, tabloid (11x17) style newsletter?
I'm new to using publisher. I used the wizard to start off creating a
newsletter in a tabloid size paper. I can't figure how to change it from a
single fold to a double fold (or actually a tri-fold) newsletter. Help!
>I'm new to using publisher. I used the wizard to start off
>newsletter in a tabloid size paper. I can't figure how to
change it from a
>single fold to a double fold (or actually a tri-fold)
Charlie, Chuck here.
You didn't say what version, but in 2003. Open a new
publication,...Go to the begining of the txt file after using getline()
Go to the begining of the txt file after using getline()
I use fstream, open() and getline() to take a whole line from the text file.
I would like to know how I can set the value of the file pointer to the
beginning of the file without closing (with close() ) to start using
I need to do it many times and I think that making that without closing and
reopening file thousands times will save much time.
Could you advise me.
"Alur" <Alur@discussions.microsoft.com> wrote in message
news:CD7B7AFF-6057-4C37-955A-CADA73781B3...File open dialog shown with old style box
When I use the following code
CFileDialog dlg(FALSE, DefaultExtent, filename, OFN_EXPLORER |
OFN_HIDEREADONLY | OFN_PATHMUSTEXIST | OFN_OVERWRITEPROMPT, Filter);
dlg.m_ofn.lpstrTitle = Title;
dlg.m_ofn.lpstrInitialDir = InitialDir;
if (dlg.DoModal() == IDOK)
filename = dlg.GetPathName();
I get a old style dialog box without the tool bar on the left side for My
Documents, Desktop etc.
How do I get the new style box?
I'm using Visual C++ 6.0.
Use GetOpenFileName instead. I think the hook function that they have for
MFC common dialogs screws that up.
me...Some sent items r going 2 junk email folder,filter is off,how fix
Outlook 2007, XP pro, Having a problem with some of the sent items going to
the junk email folder instead of being sent. Junk email filter is turned off,
data base is fairly large at over 14 gb but had been up to 18gb with no
problems. Any suggestions how to fix this otr why its even happening?
Are you running a 3rd party spam filter? I've never heard of Outlook's junk
e-mail filter even looking at outgoing messages, much less putting them in
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.officeforlawyers....Automatically go Offline?
When our Sales Reps are at the office and are synchronizing the Outlook
Client (going online) at the start of the working day, some times they forget
to go offline again at the end of the day. Result: The Outlook client cannot
be used when working in the field (message: access denied, cannot find
server). Is there a way to automaically go offline, when closing Outlook?
Would be great if anyone could help.
I'm afraid there is no supported way to do this int he current app.
MVP - Microsoft CRM
-------------------------------...Printing contacts address in Small booklet style
Using Outlook 2000 SP3 on Windows Me I'm trying to print my contact list
using the small booklet style, on 8 1/2 paper-portrait and pocket size 3x5
inch pages which I then cut out, punch and put in a binder. My problem is
that some names are printed without addresses while others are printed with
addresses. I want addresses printed with all of them. How can I get all
addresses to print?
Second problem is that I can't figure out how to print both sides by
printing the odd pages, turning the printed pages over and printing the even
pages. Four pages are on each sheet. T...<Enter> to go to column A?
I have a spreadsheet in which the <Enter> key causes the cursor to
move one column to the right. But, when in the last column for this
sheet I'd like the <Enter> key to cause the cursor to drop down one
row and go to column A. I know this can be done with a macro, but can
is there a way that this can be done solely with the <Enter> key?
Not solely with the <enter> key but you can use the Tab key to move to the right
as you enter data.
When you get to last column hit <enter> key to go back to start column one row
Note: <enter> ke...Email activities from CRM not going out to Outlook
We're new with CRM and our users are complaining that email activities
from CRM not going out to Outlook. I am not sure whether this ever
worked before. I tried creating an email activity from an account and
sending it to myself and I didn't get anything.
I looked around CRM Help and some posts on this group and this is my
- Email sent from CRM as email activities do NOT go out as regular
emails, they just sit as email-type activities in the recipient's CRM
- To send out regular emails, you have to send them from Outlook and
use the "Regarding&qu...I go to send something
2:44 AM 9/6/2007
I go to send something from MS Outlook 2003, I receive e-mail messages.
What should I do to correct this problem?
"Barry Karas" <firstname.lastname@example.org> wrote in message
> 2:44 AM 9/6/2007
> I go to send something from MS Outlook 2003, I receive e-mail messages.
> What should I do to correct this problem?
> Thank you,
> Barry Karas
Eh? Outlook is SUPPOSED to receive email messages. That's what it's for.....
Please be a bit more...going back to 2003 from 2007 ! PLEASE HELP
I have recently downloaded the trial for microsoft 2007 but do not want to
upgrade to 2007 since I dont like the settings better than the 2003 version
that came with my laptop, so how do I go back to my 2003 version?
Uninstall the trial version and reinstall Office 2003 from your original
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"helpmegetaclue" <email@example.com> wrote in message
>I have recently downl...cash receipts able to go straight to the bank reconciliation
Right now you are forced to assign cash receipts to a "bank deposit" entry in
order for them to appear on the bank reconciliation. We would like to see an
option to bypass the deposit entry and go straight to the bank reconciliation.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree&quo...Can't go to 'Last Record' in one step in a Word doc. linked To Exc
I have a excel spreadsheet linked to a word document. I can go to the last
record one at a time but cannot use the 'last record' feature as it returns
me to the first record.
The 'first record' feature works. Also the record I was on in a previous use
is still there when I return.
...Cannot Omit or Change Name When Printing in Memo Style- Office 2003 #2
Cannot Omit or Change Name When Printing in Memo Style by
outlook 2003. Any help is appreciated.
I'm working in vc++6.0 in win 2000 and I want that my MDI Application
look like XP Application. Menu I arledy done, but how chage button and
thanks for reply
Nietoperz from Poland
firstname.lastname@example.org (Nietoperz) wrote in message news:<email@example.com>...
> I'm working in vc++6.0 in win 2000 and I want that my MDI Application
> look like XP Application. Menu I arledy done, but how chage button and
> dialog window??
> thanks for reply
> Nietoperz from Poland
Not...How would I go about getting these results?
ContactID ProjectID RoleID
1 1 1
1 2 2
1 3 1
2 1 1
2 2 2
How would I return the results where the noly record to show would be the
3rd one where there is no one with the RoleID of 2.
Stated differently, how do I exclude all records where there is someone with
a RoleID = 1 AND 2 and return only records that have ONLY someone with RoleID
I hope this makes sense. Thanks.
I am missing something.
Why is row 3 returned as Con...Contacts go Poof ...
I have a user that opened outlook 2003 and noticed his contacts were gone.
That same user had opened his email from another system that morning and all
was there. Accoding to his knowledge he did not delete any contacts. He is
working directly off the Exchange 2000 server. He did not have any contacts
in his deleted items to restore. My server retention policy is set to 5
days. It seams that I may have no choice but to restore from backup, which I
haven't done before either. I know there are tools like Powercontrols from
ontrack that might help me but Windows Backup wants to ...Styles for chart
Hello every one,
I am wondering if it is possible to create style for chats.
For example i want to create styles so for each chart i can apply
directly the style (say TitleStyle for titles, Axisstyle for axis,
legendstyle for legends and so forth).
Or is there another way to make charts consistents instead of doing it
Thank you in advance for the support
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Start with a chart with required format
Right click on ...Opportunity Attributes Going Blank after Save
I have a problem where attributes are clearing out after saving an
opportunity record. There is not an On Save event enabled and the On Load has
been disabled to see if that would fix it. When you save within the
opportunity, the data stays on the screen, but is not saving to the database.
Anyone have any suggestions as to what might be causing this?
Power Time Corporation
This is usually caused by a SQL problem preventing the data from been saved -
if you look at the Event Logs on both the CRM Server and SQL Server, there
should be an error entry with some further det...cannot go offline
When I try to go offline with the SFO client I get a "CRM for Outlook cannot
go Offline. The Microsoft CRM server was not found." I can access clients
and accounts from SFO but cannot go offline.
I am evaluating MSCRM and have Virtual PC installed on a local PC. I
installed WXP sp1 Office 2003. Could this be a problem? Everything else in
SFO seems to be working.
Thanks in advance
There are many flaws with SFO in the current version, and many reasons why
you may not be able to go offline. The Outlook integration is being totally
re-done for the next release of CRM (ve...xp style
I have a program with an own GUI lib.
The classes are derivide from the MFC classes.
To control the memory usage - I use the windows task manager with the
I open a frame from my dispatcher and close the frame.
With Theme: 'Windows Classic',
- all the addional create GDI-Objects of the frame are killed after I
close the frame.
With Theme: 'XP Style'
- there are addional GDI-Objects after every open+close the frame.
Does anybody know what to do ?
>I open a frame from my dispatcher and close the frame.
>With Them...Emails sent to Dist List do not go to all Members
New job, and company is running Exch 5.5 due to UK Corp/HQ decision.
When emails are sent to a certain group as an entry in a list of recipients,
not all members of the group receive the email. If the email is sent just to
the group all members of the group receive the email.
Does this happen every time? Or did someone send a message to some users and
the group, and people in the group claimed they didn't get the email, then
you sent a message to the group alone, and sure enough, they all got it.
Here's what to do- do nothing, when a...can't use Windows Mail
I have a yahoo.co.uk e-mail address and have used Windows Mail in conjunction
with that e-mail address for a long time now. Two days ago it suddenly
decided that it required me to sign in to be able to retrieve/send my mail.
I have entered my username and the correct password in a whole heap of
different ways but it just keeps rejecting anything I type in even though I
know that they are correct. I have even checked all the settings against my
husband's computer and they are the same other than the username and yet he
can still use his Windows Mail account but I can't ...changing style of legend
I'm trying to change the style of a part of the entry in the legend and to apply the original style - lik
in the sheet (with uppercase and other styles
what should I do?
...Using outlook.prf to prevent users from having to go thru the Outlook Setup wizard to find their mailbox
Does any expert have any experience following with the outlook.prf file so
that everyone logging into to say a given workstation will not have to go
thru the Outlook Setup wizard to find their mailbox?
I don't use the prf file, but rather the Custom INstallation Wizard from the
Office Resource Kit, which creates a MST to alter the default Office
Microsoft MVP - Terminal Server
> Does any expert have any experience following with t...