Posts by Egad

  • Installing events into all sheets automatically?

    How about something like this in your ThisWorkbook module?


    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
    ByVal Target As Excel.Range)
    If Sh.Name = "Sheet1" And Target.Column = 2 Then MsgBox "hello"
    If Sh.Name = "Sheet2" And Target.Column = 4 Then MyModule_TheMacroDoingallthestuffIneed
    End Sub

  • Paranormal Activity

    I have been experiencing some paranormal activity in my email and U2U inboxes.
    It's spooky. :stare:
    Is it just me or is anyone else experiencing this phenomenon?
    On the plus side it seems to have scared off Ngbugo Myguto from Nigeria.

  • Sharing: Create your own storm

    Thanks Tom, I've been busy lately, and haven't had time to post - hopefully I can be more active here in the New Year. I'm off :bike: to Texas/Chihuahua for Christmas and it pains me to be offline for 3 weeks. Inlaws and no computer. Priceless.

  • Eric the Mini Explorer

    Thanks Will, but I don't think I can mail him to you that quickly - especially with the post office's pre Christmas rush - the cutoff date for UK bound mail was Dec 8th.
    U2U me a mailing address if you're interested.

  • Eric the Mini Explorer

    Hi guys,
    I've received a paper doll cutout named "Eric" from a school deep-ina-heart-of-Texas. I'm to send the class a local photo of Eric along with a letter and/or postcard, then send Eric off to friend somewhere else on this big planet. The class will plot his progress and learn about different cultures and places.


    Anybody interested in boarding this intrepid Texan(click for pic.) and showing him around town. He's a nice boy, I'm not sure if he :cheers: or :music: but maybe he'll let his hair down once he gets out of state.

  • Wisdom From Bill Gag Gates

    Quote

    Originally posted by AUSSIECOMM
    Hmmmmmmmmmm, certainly gives me, for one, a whole new perspective on Bill Gates!!!!! Not a bad sort after all.


    It's ok Aussie/Will, you can go back to disliking Bill. He didn't write it. Snopes is my friend. :)


    http://www.snopes.com/language/document/liferule.htm


    < snip &gt;
    This list is the work of Charles J. Sykes, author of the book Dumbing Down Our Kids: Why American Children Feel Good About Themselves But Can't Read, Write, Or Add. (The list has appeared in newspapers, although not necessarily in this book.) Many versions of this list omit the last three rules:



    Rule No. 12: Smoking does not make you look cool. It makes you look moronic. Next time you're out cruising, watch an 11-year-old with a butt in his mouth. That's what you look like to anyone over 20. Ditto for "expressing yourself" with purple hair and/or pierced body parts.
    Rule No. 13: You are not immortal. (See Rule No. 12.) If you are under the impression that living fast, dying young and leaving a beautiful corpse is romantic, you obviously haven't seen one of your peers at room temperature lately.


    Rule No. 14: Enjoy this while you can. Sure parents are a pain, school's a bother, and life is depressing. But someday you'll realize how wonderful it was to be a kid. Maybe you should start now. You're welcome.
    </ snip &gt;

  • HAYNES MANUAL - THE REAL MEANINGS

    HAYNES MANUAL - THE REAL MEANINGS
    For those of us that have ever used a Haynes Manual in attempting home
    maintenance of a car. For those who have not used a Haynes Manual, these are
    the books aimed at car-owners who want to fix their own cars and which keep
    qualified mechanics in paid employment putting things right afterwards. They
    are chock full of photos, diagrams and step-by-step instructions which are
    obvious if you are a fully qualified motor mechanic, but which are
    frighteningly sparse on detail for the average Joe in the street who wants
    to change a set of spark plugs on a 1981 VW Polo ....



    http://www.shartwell.freeserve…umor-site/real-haynes.htm

  • This made me laugh !!!

    Who wants to be a Millionaire - Irish contestant


    Chris Tarrant -


    "OK Paddy. You have three life lines and you want to use one of them at this stage - which would you like to use?"


    Paddy - "I'll phone a friend please Chris"


    Chris Tarrant - "Who do you want to phone Paddy?"


    Paddy - "I'll phone Tommy please Chris"


    Brrrrrr. Brrrrrrrrr.


    Tommy - "Hello"


    Chris Tarrant - "Tommy??"


    Tommy - "Yes"


    Chris Tarrant - "It's Chris Tarrant on ITV's Who wants to be a Millionaire."


    Tommy - "Christ"


    Chris Tarrant - "I've Paddy here & he needs your help to get him to 2,000, the next voice you hear will be Paddy".....




    Paddy - "Tommy, will I go 50/50 or should I ask the audience?"..........

  • Freezing Titles - on the web

    Ok, its my turn to ask a question. :)
    When an Excel file is opened via the intranet or browser all controls, menus and macos work but the Window menu does not show.
    Windows-Freeze Frames or Windows-Split canot be used.
    The end-user prefers opening the file over the intranet. I think I could add a VBA freeze-frame button w/code that would work on the web and will test that out.


    Does anyone have any insights, comments or non-code solution?


    Thx, Doug

  • VBA: Cel Naming or Reference

    Hi D, and welcome to the Forum.
    How about some code that saves the sum formula, clears the column, then replaces the formula?
    You would have to name the cell (ie "test") using Insert-Name-Define that contained the formula that you want to save or just reference the cell address (ie B10)


    Sub test()
    z = Range("test").Formula
    Range("b:b").Clear
    Range("test") = z
    End Sub


    or


    Sub test()
    z = sheets("sheetname").Range("b10").Formula
    Range("b:b").Clear
    sheets("sheetname").Range("b10") = z
    End Sub

  • Down the memory lane

    Whoa, you guys had C64s? All I had was a Sinclair ZX81 that wailed like a banshee when I stored or retreived programs from audio cassettes.
    My first business computer was an ICL (British made in Japan?) running MPM (think networked CPM). We almost went for the 5mb disk but upgraded to 10mb even though the consultant said we'd never fill the 5mb. Our main app was a database called FMS-80. I was totally giddy when I saw my first spreadsheet and realized the possibilites.