Page break in normal view set at startup
Excel 2003. Is it possible to have Excel with Tool/Options/View/Page Break
always set at startup.
try adding the following VBA code to the workbook
ActiveSheet.DisplayAutomaticPageBreaks = True
HiArt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19953
View this thread: http://www.excelforum.com/showthread.php?threadid=402065
Do you mean for a particular workbook or f...Help
In the last three days, I have unable to download
attachments. Previously I had no problem. When I
attempt to open my attachments, I get a window called
File Conversion filled with ASCII characters. Need info
on how to correct this.
It sounds as if these attachments are defaulting to Microsoft Word to open.
What types of files are these? What are the file extensions?
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Manville" <email@example.com&g...help help remote login
i need to access the exchange server remotly. we have a vpn set up and i
don't know how to get in to do simple things like delete the bad mail folder
ect.. or access simple files. if some one could guide me the right way or
help it would be muc appriciated.
Have you considered remote desktop?
"tmolaee" <firstname.lastname@example.org> wrote in message
>i need to access the exchange server remotly. we have a vpn set up and i
> don't know how to get in to do simple things like dele...Bill Pay functions (new to Money)
I'm just setting up and learning my Microsoft Money.
I already pay my bills (some automatically, some manually) through my local
bank checking account. I have added that account to Money.
If I set up Money's bill pay, are my bills going to get paid TWICE?
"ConnieVH" <ConnieVH@discussions.microsoft.com> wrote in message
> I'm just setting up and learning my Microsoft Money.
> I already pay my bills (some automatically, some manually) through my
> bank checking account. I have added t...Supplemental info to "HELP-excel date malfunction
Here's some additional info to the earlier post on the
date cell function malfunction. Been isolated to the
function to insert the date (cell format/date). It seems the
application cannot interpret the system date properly.
Always inserts/interprets the date as CurrentMonth-01-2011,
instead of actual date. I cannot use the application this
way. I am using the 'general' setting in cell format, then
entering the string Month(abr)-day [eg= dec-17] instead of
letting application enter the date automatically.
Is there a patch available for this issue?
Visit Family Rad...HELP!!!!!!!
I'm doing a sheet at work and I'm having some problems, I need your help!
Whay I have is a sheet with some columns and rows.
- 1: Can I put "filters" on SOME columns only? I can put filter with
auto-filter to all columns, but it makes no sense... How to put on SOME only?
- 2: Can I auto create a book when inserting some data on a cell (write down
something on a blank cell)? use the same name as text written on cell?
- 3: Complete some cells auto from specific cells on other sheet (file) of
- 4: Hide some columns so some users on a Domain don't see......help
how to enlarge publisher business card to letter size 8.5x11
A single card?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"notoes" <email@example.com> wrote in message
> how to enlarge publisher business card to letter size 8.5x11
must have a big wallet to keep them in
Microsoft MVP Expression Web
"JoAnn Paules" <firstname.lastname@example.org> wrote i...Urgent Help Required on Excel Macro Problem
We are facing one problem from around 2 months.Some of our users have
XF_SIC.A virus found in their pc.XF_SIC.A virus generally found in excel
workbook as macro virus.This virus create one excel 4.0 macro sheet with
"very hidden and very protected" attributes in excel 97 workbooks which can't
be removed as it is not seen.every time when infected excel 97 file opens it
infect the default startup excel file(Book1 placed in XLSTART folder) and
then every excel file that will be open will have infection as default file
book1 infected.now our antivirus software mcafe...Quotes in money 2007 stopped working
Anyone else having problems with Money 2007 downloading quotes? Mine
stopped about 10 am.
Same here JC.
"JC" <email@example.com> wrote in message
> Anyone else having problems with Money 2007 downloading quotes? Mine
> stopped about 10 am.
....Net passport account and MSN Money website
I am attempting to start over with my money account
because of problems converting to 2005. When I link the
account to my passport account it brings all the old
recurring transactions to the new account and they are
WAY old. Is there any way to clean them from the MSN
money website before I associate my .net account with my
money file?. When I go out to moneycentral to view my
reccurring bills and deposits nothing is listed.
Thanks for any help.
This is supposed to be accomplished by resetting the data. Log in to the
Passport you want to clean out and then go to
https://moneycentr...Help: how to print fill pattern well in any printers
As we know, for display, we can call
CreatePatternBrush() to create a 8pixel * 8pixel to fill a region.
It is perfect for display in the display device and some printers.
But In some high-res printer, the fill pattern is printed as gray. (the fill
pattern is printed so densy that it looks like a solid gray block, for
example, some HP printers and Acrobat PDF printer).
I have tried a bigger bitmap brush according to the printer device's
But It is still bad for some printers.
Any suggestion is appreciated.
Is there any way that is suitable for any printers?
...How to access help?
That office assistant thing is useless to me. It says you can switch it off
And where do I find stock standard help? Or does that only come up when
you've got the paperclip switched off? In which case, again, how do I switch
the thing off?
How to modify or remove Office Assistant Help in Office 2000
Mary Sauer MSFT MVP
"abrogard" <firstname.lastname@example.org> wrote in message
news:36DF541B-4845-454E-B610-4BA5DFD28952@mi...'Save As' hangs Excel XP 2002 SP3
I have a problem in our office. For the most part Excel works fine. We can
open files and save them as long as we dont use the 'Save As' feature and try
to save it to a Network Drive. Files can be saved locally then have to be
copied to the Network Share.
Of course my first reaction was 'Permissions Issue'. BUt each user has full
access to the folder. They can right click and create a new Excel file and
rename it. BUt if they open that same file then try to 'Save As' back to the
same folder Excel hangs. Using the 'Save' feature works just fine.
...Account totals missing in Portfolio Manager after switch to Money
When I switched from Money 2005 to Money 2006, somr of my investments no
longer have a Total Account Value. The line is just blank. This leads to an
incorrect total at the bottom of the page. How can I get Money to calculate
the totals accurately?
...Help with RecordSetClone
this is my first attempt at using recordsetclone to look at the same field
on a continuous form and update the field. I have looked at other examples
on this forum and put together the below code but I keep getting an "invalid
argument 3001 error" when it reaches the first .FindNext.
.Bookmark = Me!subfrmPersons.Form.Bookmark
MsgBox Me!subfrmPersons.Form![DOB] 'for testing only
If Not IsNull(Me!subfrmPersons.Form![DOB]) Then Me!subfrmPersons.Form!
[Age]...Little help, 5.5 to 2k3 migration problems (long)
First post here, so I apologise in advance if I get anything too wrong, or
it's too long.
I had Exch 5.5 running on a Win2k domain controller, 60 odd users, some
public folders, some delegate access etc. I decided to migrate the system
to a Win2003 / Exchange 2k3 server, following the deployment instaurations
on the CD.
*Note: on further investigation on the KB, it seems that I should have run
the 5.5 DS/IS constancy checker before the migration to iron out any ACL/AD
issues - this wasn't done. I have also discovered that my original ex5.5
site name contained invalid character...excel help 04-09-10
I have a table (range a5:s33) that is changing constantly and its being
updated. I need cell I1 and I2 to give me the date (I1) and time (I2) when
any of the cells within the range are modified....any help?...thanks
Try the following Sheets Event-Macro:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A5:S33]) Is Nothing Then
[I1] = Date
[I2] = Time
> I have a table (ran...money replacement 03-26-10
OK, so I've learned that Microsoft no longer offers a "Money" product. Can
anyone recommend a comparable replacement for my stand-alone MS Money 2007
software? Office Accounting Express looks powerful but I thing it is too
complicated for my personal finance needs. What about an online offering
(though I'm not really keen on the idea).
Thanks for any suggestions.
In microsoft.public.money, Domenick wrote:
>OK, so I've learned that Microsoft no longer offers a "Money" product. Can
>anyone recommend a comparable replacement for my stand-alo...Encryption problem with Money 2004 Business
I recedntly purchased a new lap top and tried to load Microsoft Money 2004
Small Bussiness and the program refused to run. An error message appears
that states that The system cannot encryt date at the desired level.
All Internet Explorere and Microsoft Windows XP upgrades are in place. Any
In microsoft.public.money, Razorback Jack wrote:
>I recedntly purchased a new lap top and tried to load Microsoft Money 2004
>Small Bussiness and the program refused to run. An error message appears
>that states that The system cannot encryt date at the de...money upgrade problem with online services.
I just upgraded to Money 2005 Deluxe trial version and I can't get my
accounts to work online. I go to manage online services and i click set up
online services, choose the account type, select the bank, then it gives me
the add a new account screen (which actually adds another account, instead of
adding services to my existing account). If i try to follow through with
actually putting the info in...it just hangs forever and then it fails.
...Excel data completely disappeared
Please can someone help me with a problem I am having.
I created a spreadsheet with Excel and included a 'comments' column
designed to appear with a mouseover.
I saved the spreadsheet and tested it out, everything ok ... until I
went to view it the next day and every single comment has disappeared
Even the red triangles have completely disappeared ... this is really
Can anyone throw any light on this ?
cool4cats's Profile: http://www.excelforum.com/member.php?actio...tab key freezes, hangs computer
When I use the tab key to move from field to field in
Outlook, my computer hangs up - it just freezes. Any
...Outlook 2007 hang on received external meeting request
If this meeting request is opened by the same user with outlook 2003 its opens without problem.
Exchange 2007 SP1 Rolup 2.
...Help with referencing multiple sheets in formulas
I have a workbook with 32 sheets, The first sheet is a month summary
the other 31 sheets are for each day of the month.
The sheets are names month,1,2,3..31
I need to copy information from the daily sheets to create a summary
the month sheet like follows
1 Day Turnover .....
2 1 ='1'!E7
3 2 ='2'!E7
4 3 ...
5 5 ='5'!E7
Is there a way to substitute the sheet name from the column Day
manually having to enter each formula. There will be a number of
and I have a number of similar workbooks to make.
IE for B2 a formula l...Need help with excel sorting/comparing funcations
HI all, the list I am working on consist of phone number, date, conversation
start time, conversation end time.
and there around 3476 records in one file and 2477 records in another...
and they are not in the same format...
so what I did was to sort out all the relative infomation in one file by its
phone number, and did the same for the other one
then I copy and pasted both lists in a new file.. and did the above
comparesion.. nothing showed up or just gives me errors..
I am doing some analysis for our datebase records...... the sample I took
out is only the small part.. the real f...