Recent content by SteveMersereau

Using conditional formatting, you'll need to start by formatting one row. Select the row. (Row 1 for this example) Format -> Conditional formatting Condition 1 -> Formula is -> =A4=Paid (it's A4 because you're on row A and Column 4 (D) is the one you're testing) Click Format.. and select...

Thanks for both these posts. Tony, would you give me a pointer to setting up a palette please.... Thanks! Steve "...it's just me, putting my hand on my heart

Is it possible to use code to restrict the colours a user can choose for font / cell bg within Excel...? A client wants to allow only corporate colours in a workbook. If impossible, any thoughts welcome. Steve "And all of this is not imagination

Is it possible to use code (or without using code) to restrict the colours a user can choose within Excel...? A client wants to allow only corporate colours in a workbook. Steve "And all of this is not imagination

This was great! You've both made me very happy. Steve "Love has no meaning, not where we come from

Thanks for your lightning-fast response. Apologies for not being clear! 1 FormField Textboxes 2 To get text entered into the boxes after a button press 3 The idea is to for a Word doc to consist of a series of text boxes, similar to a questionaire. The end user will take this document and...

I'd like to refer to a number of textboxes from within a module (There may be 20 or 30 so I can't pass as parameters). Any ideas as to syntax? Thanks! Steve "In the Jungle of the Senses

Did you ever figure out how to do this? Steve "In the Jungle of the Senses

Thanks to everyone. Job done! Steve

I need to write some code to save the current Autofilter state, then clear all filters, then do some stuff I've already written, then, finally restore the original autofilter state. All help appreciated! Steve "In the Jungle of the Senses

Also, use the code inspector thing to see if there's a rogue   in there! Love, Steve "Don't dream it, be it"

Holy Cow, that was fast! yando's solution works well; Discord's seems to work well also, although I haven't tested it fully yet. Thousands of thanks! Love, Steve "Tinkerbell, and Jack the Ripper"

This is what I want...! User clicks on an image link, a pop up window opens with a bigger version of the image. So far, so simple! The problem I'm having is passing a variable to the function to define the size of the opened window. The code I've got is this; <SCRIPT language=JavaScript>...

Did you ever get an answer to this? Love, Steve &quot;Give the anarchist a cigarette....&quot;

Thx TulsaJeff and OldNewbie.... it's working fine now. I love Netscape 4.79 and I love Flash and I love you!! Love, Steve I'm ready, that's that, that's final, it's a wrap You win, come on, drive me to the bar