Recent content by Redpop

Thank you for your attnetion. The nature of the text they enter is variable. It's a description of a project. Sometimes it will have bullets, often times not. It depends on the user's writing style. They've learned the Alt-Fn-7 'bullet character' trick, but see that as a workaround. There...

OK, good stuff so far.. I could live without the 'form' but it does a few things for me: • It makes the checkbox work like a checkbox with one click (there's no linked code, it's just visual) • It keeps formatting consistent • It keeps users from changing other areas of the document However, as...

I've created several 'forms' in Word 2003 (xp) that use protection ('Protect Form' on the Forms toolbar) mostly to allow a checkbox to function, but also to keep formatting sane in these customer-facing documents. The form fields are a bit difficult for my users to handle. They want to use...

Wow. Just like that, huh? I tried this on one of the other users' computers, and it's exactly as you say. Thanks so much for the help!

Below is a formula that references a range on another tab, and uses 'IF' and 'NETWORKDAYS' functions. This formula (created in Excel 2003) works for me but not for my intended users using Excel 2000 and 2003. It comes from a project-tracking list, where column 'C' is the report date, 'H' is...

Fabulous! Worked like a charm.. all the way through. Thanks again!

My predecessor in this analyst position has written some dandy macros to facilitate automated report processing. He wrote them in Excel 2000, where I have 2003. This particular macro is one of many in a larger macro. The big one creates a new group of files from a single worksheet from rows...