Replies

RE: For emergencies, however, I do retain a rudimentary Administrator profile on the C drive.

How can you have an administrator profile on C if the All Users folder is set to another drive in
My ComputerHKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionProfileListProfilesDirectory?

Won’t there be a conflict?

– Al

Yep I’m familiar with AutoArrange. I always disable it. No selections are checked for icons, which is the way I want it. This way I can place icons wherever I want on the dektop. This behavior only started recently (last 4 months) and on two different systems I use. Must be my magic touch …

– Al

In O2002: Go to Tools | AutoCorrect options and select the “Autoformat as you type” tab. Clear the “Internet and network paths with hyperlinks” check box. Works in all O2002 apps.

I thought that in O2000 one could disable these hyperlinks in Word and the behavior would roll over to Excel, too. Alas, doesn’t seem to work.

Sorry…

– Al

Thanks. I always the Options button to the tool bars of all Office apps. Just makes things easier. So, I done that much.

I thought the code wouldn’t be that difficult even though I’d categorize myself as a hacker… I used some of Sue Mosher’s code to create a macro to change the reply-to address. Changing the Save sent message message folder turned out to be beyond my hacker knowledge.

– Al

Turns out that in most of the Office appls you can hold down the ALT key while you move the object. This temporarily disables the sanp-to-grid behavior. There’s also another way to turn off this behavior that escapes me at the moment. While in PPT, press F1 for help and look for “snap to grid.”

– Al

K,

My default is to save a copy to the Sent folder. On a message-by-message basis, I want the ability to not save or to save to a different folder. So, I’m not concerned about the problem of always saving a copy; I want to be able to change my default setting – for an individual message, not in general.

Does this help?

– Al

Thanks very much for taking all that time to put this together. It’ll help me a lot, I’m sure.

Al

CaptainCode,

Thanks for your response and I think it’s a good policy. Certainly matches my experience with O/S drives. I’ll most likely implement it when I get an uninterruptible chunk of time on a weekend so I can maintain continuity of thought.

– Al

I have Partition Magic. Hadn’t thought re-partitioning again… I’ll check it out.

Thanks for the help,

– Al

Dave.

Thanks for your interest but there really isn’t anything that can be done. We are running the eRoom application, V5.2. eRoom is optimized, er, designed around IE. So, Netscape doesn’t display eRoom contents properly and has trouble with some of the forms. V5.2 is incompatible with IE6. Eventually, we’ll get around to upgrading but we just have other things on our plate. And 5.2 is okay….

Al

Yes. Unfortunately, this application has some problems with Netscape… Don’t get me started.

Al

I was hopeful … Guess the best solution here is to keep W2K installed and install XP separately.

Thanks,

Al

Thank you everyone. I got so wrapped up in “formularizing” that I didn’t even see the Conditional Formatting capability. This will work just fine and, thanks to Legare, I now know how to make VBA code perform cell updates upon change. This concludes what I needed.

Oops … I meant ChangeCellColor(if-this-expression-evaluates-to-“X-S”, Tan, NoFill).

Well… I was hoping to accomplish all this in a cell formula without resorting to VBA … . Something like ChangeCellColor(if-this-expression-evaluates-to-“X-S”, NoFill). I’m actually doing this for a colleague who is changing the cell color manually. The reason I’d like to avoid VBA is that it creates one more step, i.e., forcing the macro to run. Thanks.