I want to default to gridlines on any spreadsheet that I
create. How do I change my default to allow this?
Do you mean the guide gridlines, or the gridlines that
print out? To have your spreadsheet open with the grey
guide gridlines, go to Tools, Options, View, and select
Gridlines. For the printed gridlines, it is better to put
those in yourself after the creation of the spreadsheet -
you don't want every cell outlined throughout the
spreadsheet - that takes up memory, and unless you define
the print area, would print out excess pages.
Hope this helps,
>-----Origina...Message Headers #2
Is it possible to enable message headers for email sent between
mailboxes on the same mailbox store, in Exchange 2003?
> Is it possible to enable message headers for email sent between
> mailboxes on the same mailbox store, in Exchange 2003?
I do not think so. What is the goal?
If my message is helpful, please help me by registering at
http://www.openoffice.org/servlets/Join and voting for the following issues:
http://www.ope...VCF Files #2
When I try to export a Contact's info to a VCF file the notes section does
not appear. I am running Outlook 2003.
Known problem. SP1 fixes the export, but the problem with missing notes when
you open a .vcf file remains.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Maynard James Keenan" <Maynard James Keenan@discussions.microsoft.com>
wrote in message news:36E84589-7231-4334-9524-0D2BF8AB4B07@microsoft.com...
> When I try to ...2 Forms and 2 tables
there are 2 forms (main & sub)
when i make a new record in main form,
the new record is not yet saved / created in table
then i click the sub form button (by macro - openform) for creating
sub-record of this new record.
but there is error cos the new record (main form) has not been created and
so the sub record cannot be created too.
how should i do?
i do not find save macro command so that i can save the main form record
before creating subform record.
Thanks a lot.
The macro Action to save the record is RunCommand/SaveRecord.
But I would normally expect that t...no-ip with exch 2003 #2
I am unable to get my DDNS service to work with exchange 2003. I am sure it
is the way I have it configured on my end. Every message sits in the queue
and says unable to connect with the server or unable to deliver the message
in the time specified.
I can do a nslookup q=mx and it's there but that's for the no-ip MX record.
What sould my local MX recrord FQDN read?
What should my FQDN be of the Exch (SMTP) Server?
On Tue, 09 Nov 2004 19:02:05 GMT, "Brian Paris"
>I am unable to get my DDNS service to work with exchange 2003. I...Backup pst #2
I have unistalled pfbackup (I thought)and wanted to
reinstall it. However the installation detects a previous
installation and suggests unistalling it by clicking "OK".
It then gives a dialogue saying it will have to be
unistalled from windows Add/Remove programs in the
Control Panel, but it isn't there either.
Any clues out there to help me?
...Combine 2 macros into 1
hi i need to combine 2 macros.
im not the best at macros, but i cut,paste and adjusted this together
i have 2 buttons on my toolbar.
1st button converts all text or selected text to upper or proper case
2nd button converts all text or selected text to lower or sentance case
the problem i have is my MsgBox only had 3 buttons. so i could use the
yes/no with an if else. i dont know how to add more buttons (im pretty
sure it has something todo with that "vbYesNoCancel" line, and even if i
did, i dont know how to add more if's to attach the macros to the
i used to be a...Index and Match #2
OK, here's my question.
I have a list of a set of values listed below:
=INDEX(REP,MATCH(MAX(Total),Total,0)) <--Max Value(16955),Peter
=INDEX(REP,MATCH(MIN(Total),Total,0)) <--Min Value(11986),Steve
I want to, based on value, sort these on another sheet. Using the
formula above, I can get the MAX and MIN. How do I go about getting
the rest of the values sorted accordingly?
Why nit just copy them, and then sort them?
(remove nothere from the email addre...Print Layout View #2
I would like to use the Print Layout view when drafting email messages. Is
there a way I can make that the default?
...How save a lotus 2.2 file in excel and to open it in excel and pe.
Have been using a lotus 2.2 self created accounting template. Create Income &
Expense statement and balance sheet. Imput comes from a check register in
which you enter the amount of the check in a cash credit colums or deposit in
the cash debit column along with an account number on the same row as the
entry. The account number transfers the amount to the proper line item in
either of the two statements (cumilitive) Would like to do the same thing in
Excel?? Problem lotus is in dos and excel in windows.
Would appreciate any suggestions
...Installing .net 2.0 on with Windows Sharepoint Services spk 2
I have WSS with SP2 running on server 2003 with SQL 2000 Enterprise. All
is running fine. I am planning on adding .net 2.0 and possibly sql 2005
express to the server. I plan on keeping the WSS site on .net 1.1. My
question is when I do the ugprade is there anything o the WSS site or
administration that I have to do after I have have installed the .net 2.0
framework? I just want to make sure I do not break anything or mess up any
rights I have setup on the site. Thanks a bunch for any advise. Yes I will be
making an image of the server before upgrading.
On Fri,...2003 to 2004 #2
I have money 2003 now if I get money 2004 will all the
info form 2003 transfer to 2004?
>I have money 2003 now if I get money 2004 will all the
>info form 2003 transfer to 2004?
Provided you are in the same region i.e. US > US or UK > UK.
Microsoft MVP - Money
"Brian" <email@example.com> wrote in message
hello my dearest developers,
I encounterd the following problem...
Supposing that i a row full of data inevery cell Microsoft excell and all
rows are full.
I'd like now to "transpose" the row into column while inserting the data
without overwriting the existing data.
I'm waiting for ur precious help.
One way ..
Assuming source data is Sheet1,
with entire rows filled from row1 to a max of row256
(btw 256 rows deep is the max possible for transposing
to columns as there's only 256 columns per sheet!)
In a new Sheet2
Put in A1: =OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
C...Check numbers #2
Does anyone know if it's possible to print checks in reverse order. We
would like to print from 100-1 instead of 1-100. Our printer takes the page
from the bottom of the pile and rearranging is a pain.
Isn't this something you can set in the printer properties? On my hp i can
go into the printing preferences and tell it to print the last page first...
> Does anyone know if it's possible to print checks in reverse order. We
> would like to print from 100-1 instead of 1-100. O...help!!! #2
Can somebody tell me the name and location of the file
that holds the address book? I have reinstall the outlook
and imported the contacts from a comma delimited file, all
of the contacts appear on the contact folder but when I
open a new message window and click on the TO: button to
add recipients a message saying that the address book
could not be found and after that it shows a window asking
for the proper list to show in a drop down list; that drop
down list says 3 times the word "contacts" and if I select
the second then all the contacts would appear but I don't
kn...giving Permission for EVERY Task ? #2
UserA create 2 tasks: Task1 and Task2
is it possible to give permission (Mofigy, delete the task) to some
Users for every task,
For example only for Task1 (no permission given to others for Task2).
I appeciate any help
See my response to your other post on this issue.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Faure" <firstname.lastname@example.org> wrote in message
> Use...Great Plains Version 8.2
We are still runnin GP Ver 8.2. We have 2 companies on
it. Suddenly I can't work in the 2nd company. Every
screen I try to go in I get a message that it its in use,
please try later. Can anyone help?
We have had this issue alot. It happens when someone logs
out of Dynamics inproperly. To fix this you need to have
the admin login to dynamics. Under setup choose system and
enter in the password to access the system information.
Once this has been entered you will get another menu
selection one which is 'User Activity'. Open this up and
you will have a list of all users w...Win32/PSW.Lineage.DN/ PWS-Lineage virus Message
I was hoping that someone could either answer this question or direct me to a
place where I could find an answer in another forum. I thought this was a
good place to start.
I have a PC game called Air Conflicts on my Dell Inspiron 1501 running Vista
There have been a couple of times recently when my MS Calendar interrupted
the game by popping up an event reminder. Then, I get the following message:
Remove the Win32/PSW.Lineage.DN/ PWS-Lineage virus from your computer
This problem was caused by Win32/PSW.Lineage.DN/ PWS-L...PartyPoker offer #2
PartyPoker.com is the world's largest and most trusted online poker
room! Since opening it's doors in 2001, they have been serving lots of
fun and excitement to poker players worldwide and are growing at record
speeds by offering lots of games and limits, excellent customer care
and maintaining the highest level of integrity, security, and
Licensed, Regulated and Tested
PartyPoker.com is licensed and regulated by the Government of
Gibraltar. The games are powered by the iGlobalMedia system which is
tested by iTech Labs, a leading independent tester of gaming and
wagerin...bmp display #2
i want to display a bitmap in a picture box.I was not
able to do it.When i use loadimage(filename),i was
returned zero by the function.Where will i get the source
to display a bmp image.please share some time for me.
Following shows how to use LoadImage:
Ajay Kalra [MVP - VC++]
"susi" <email@example.com> wrote in message
> i want to display a bitmap in a picture box.I was not
> able to do it.When i ...2 questions #2
how do i get a total for a list of names entered in
ie alan billy chris dave ......
also is it possible for the date to be automatically enterd in each sheet
You have a list of names in a row?
=COUNTA(A1:Z1) for row 1 or =COUNTA(1:1)
In a column ?
=COUNTA(C1:C100) for column C or =COUNTA(C:C)
Whereas COUNT counts numbers, COUNTA counts everything.
=TODAY() add the current date which updates when the file is opened tomorrow
Using CTRL+; enter the current date in static form - will be yesterday's
Bernard V Liengme
I forgot the password of the worksheet. Let me know if there is other enable
I have no idea what this means, sorry.
gearoi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26576
View this thread: http://www.excelforum.com/showthread.php?threadid=401916
Good afternoon Conditional Formatting
Try looking here. Ithink it will help you with what you're asking:
---------------...Design checker question #2
I often get an "error" in design checker that says "Object is not
visible." When I right-click and choose "Go to this item", nothing
apparent happens. When I choose "Fix: bring object to front", nothing
happens, and the error message does not go away.
What am I missing here?
Select all, give everything a line. Does the phantom object show up? If it does,
make a note where it is and do an "undo." At least you will know the area where
to try to delete the object.
"Craig Schiller" &l...outlook problem #2
I have win2000 os with sp6. I can't send an email...get
error message 'outlook.exe has generated an error'
interesting as there is no sp6 for windows 2000. (sp4 was just released a
few weeks ago)
does outlook start in safe mode? (start | run | type: outlook.exe /safe | ok
"Butch" <firstname.lastname@example.org> wrote in message
> I have win2000 os with sp6. I can't send an email...get
> error message 'outlook.exe has generated an error'
...Recipies of South INDIA #2
Do you want to know to how to make mouthwatering,spicy foods?
If you want to know how to make delicious South Indian foods please