Content Type
Profiles
Forums
Events
Everything posted by Anne Troy
-
Applying conditional formatting to Mutiple cells in one shot? Please H
Anne Troy replied to ramki's topic in Microsoft Office
Sorry for the late response. Use the format painter: http://www.officearticles.com/misc/format_...soft_office.htm -
Sorry for the late response. Why not keep it in Excel? http://www.officearticles.com/tutorials/or...osoft_excel.htm
-
Sorry for such a late response. See my article: http://www.officearticles.com/misc/about_s...soft_office.htm
-
Hitting Ctrl+Enter is a bit easier, and will do the same thing.
-
Did you back this file up to a CD and then copy it? If yes, right-click the file name (in Windows Explorer) and uncheck Read Only and then try again with Outlook.
-
Hi. Could we get the exact error message?
-
Not positive, but try this: http://support.microsoft.com/kb/287623/en-us
-
You can Insert-->Picture-->From File and choose to link it. Then hit Alt+F9 to turn on viewing of field codes. Alter the file names. When you want to see the pictures (AND they exist), hit Alt+F9 again to turn OFF viewing of the codes so you can now see the pictures. That's about the best I can offer off-hand.
-
LOL. Glad I'm not using those long formulas. You *can* sum intermediate sheets. Try this: http://www.officearticles.com/excel/sum_th..._worksheets.htm
-
A program is trying to access e-mail (Outlook 2003)
Anne Troy replied to omnifred's topic in Microsoft Office
What is the external program? -
Version? Seems similar to another question here, to which I posted this Technet Search link.
-
There appears to be several known issues. Try this Technet Search to see if any of them will help you.
-
You can probably work with something like this macro: http://vbaexpress.com/kb/getarticle.php?kb_id=38 If you don't ALSO want the value of cell A1 in the file name, just change the code to: Option Explicit Sub SvMe() Dim newFile As String ' Don't use "/" in date, invalid syntax 'Change the date format to whatever you'd like, but make sure it's in quotes newFile = Format$(Date, "mm-dd-yyyy") 'Or perhaps newFile = "myBook-"&Format$(Date, "mm-dd-yyyy") ' Change directory to suit your PC, including USER NAME ChDir _ "C:\Documents and Settings\ USER NAME \Desktop" ActiveWorkbook.SaveAs Filename:=newFile End Sub
-
Army: You need VBA to do that. See Chip Pearson's site: http://www.cpearson.com/excel/colors.htm ~Navy
-
The number [quantity] of symbols allowed in a certain field
Anne Troy replied to az0000000's topic in Microsoft Office
Sounds to me like you have the field type set as a number/integer, and it should be text. -
[Question]Outlook 2000 Hangs when closing
Anne Troy replied to averagecdn's topic in Microsoft Office
Have you run detect and repair from the help menu? When's the last time you checked the size of your PST file? Perhaps it's getting large... over 2GB? -
Don't know about network deploy, but if you just want to remove the print button, hold the Alt key and drag it off. However, Ctrl+p is a printing shortcut, you can print from Windows using right-click, and the print preview dialog usually has a print button, etc...
-
I don't know how to write it in code, but here it is as a formula: =IF(DAY(NOW())=2,TRUE,FALSE) This might help you use it: http://office.microsoft.com/en-au/assistan...1102181033.aspx
-
I'm lost. Well, try Start--->Run and type: access.exe /regserver
-
Looks like your exact issue? http://support.microsoft.com/default.aspx?...kb;en-us;870707
-
Footers -- numbering pages in Word '03
Anne Troy replied to NegativeSpace's topic in Microsoft Office
OMG! Thanks!! -
Okay. I gotcha. And a few quick comments... IF you are using a DOT file, you can create autotext entries for your 50+ text lines. Then run macros that insert the autotext. That way, if your text changes, you can just recreate the autotext instead of modifying the VBA. http://www.officearticles.com/word/using_a...rosoft_word.htm Maybe something like this will help? http://visualbasic.about.com/library/weekly/aa021503e.htm (sorry about the popup)
-
Stan: Check with your ISP. Not all ISPs will allow you to use a DIFFERENT SMTP server from their own, especially without logging into theirs first. This is likely NOT an Outlook "problem" issue, but your account setup. So, if you have, for instance, comcast.net, try using THAT as the outgoing on the account and see if it works. If it does, then try setting up your other SMTP, but use the More Settings button, Outgoing Server tab to log onto your comcast... Clear as mud?
-
Sorry, no. I'm not a Windows person and was only trying to clarify. But now you know it's a Windows issue. Perhaps you can ask the forum leaders here to move your question. Good luck!
-
1. I'm not sure why you're using a macro in the first place? 2. When I make form field entries, I first have a blank one that is as wide as I want the drop-down to appear. Just use spaces to create the first one. (I actually create it last, then move it up to the first position.) I see. Maybe you want a conditional drop-down? Try this knowledgebase entry by fumei: http://vbaexpress.com/kb/getarticle.php?kb_id=5