Posts by GrahamB

    Re: Fifa World Player Of The Year 2006

    That was quick, I was expecting more heated comments from Will and Jack.

    Too hot down under? - we got our first rain since July today, absolutely brilliant

    I think I probably won't get too many comments from Enggland as they are still basking in their win of a few years ago.....



    Hi All,

    With today's ability to work on the run, I am looking for a hand held computer/phone that can actually run Excel and its macros. I am told that most PDA that can run Excel only run limited versions of Excel that exclude macro functionality - appeciate any comments and ideas



    Re: A Survey Of Spreadsheet Users

    Hi All,

    I have read all the above comments and agree - I started using Lotus 123 in 1982 and have progressed. In every company I have worked, I used spreadsheeting for everything from scheduling, accounting, to loading systems, while other around me did it the 'old' way.

    The reason I use spreadsheets is not because I am smart, I am just lazy and I cannot stand having to do the same thing more than once. I am a self taught user and see Excel as a tool only. My company aims to improve productivity at everyturn and to do this we follow "do the right job" and "do the job right".

    I am constantly amazed how companies are prepared to spend mega bucks on systems that can be easily achieved by keeping it simple. We try to avoid special equipment, special training and special personnel - all are expensive and all tend to miss the objective of being effective and efficient. I know one company in Australia who spent $300,000 for some software to replace and Excel system, then spent another $500,000 for consultants to try and get it to work and when it didn't, refused to return to the Excel systems because they had invested too much in the 'special' system. To this day (5 years on) they persist - amazing!


    Hi all,

    I am looking for a way in VBA to prevent the workbook 'x' button being active.

    I have searched thru' previous threads and found info and code on the close 'X' button for userforms and some discussion on the workbook close 'x' button but not the code.

    Thanks in advance.... Graham

    Re: copyright


    You got me, what is IMO?

    I know WOFTAM - waste of time and money
    I know FUBar - f????ed up beyond all recognition
    I even know WANKER - Wife away, no kids, eating rubish (My wife calls me this)

    But IMO?

    I cannot even think of any thing smart


    Re: copyright

    Hi Lisa,

    The question of copyright is very tricky especially if the material is software. The way my solicitor suggested I look at it was

    1. If it was created on company computers, then the company owns it
    2. If at the time you created it, document it that is was a private development then you have an argument of ownership - you will probably lose if it was on a company computer
    3. If you created it on your computer and on your customer premises you may have some argument of ownership
    4. If created on your computer and not on your customers site, then you may have an argument if you can prove it
    4. To be certain of ownership, it has to be stated before the first keystroke.

    Your situation has 2 arguments - 1 - the company hired your services which includes the creation of processes to aid the task or 2 it did not - what was in your consulting contract?


    Re: Email "Reply" button

    G'day Solidtop,

    The code below works for Outlook (Lotus Notes is different - and way beyond me!). The code I have taken from John Walkenbach's Excel 2003 Power Programming with VBA book - worth every cent!

    Sub sendasheet()
    Activeworkbook.sendmail "[email protected]", "My sheet"
    Activeworkbook.close false
    end sub

    Is this the type of thing you are after?


    The Bathtub Test

    It doesn't hurt to take a hard look at yourself from time to time, and this
    should help get you started. During a visit to the mental asylum, a visitor
    asked the Director what the criterion was which defined whether or not a
    patient should be institutionalized.

    "Well," said the Director, "we fill up a bathtub, then we offer a teaspoon,
    a teacup and a bucket to the patient and ask him or her to empty the

    "Oh, I understand," said the visitor. "A normal person would use the bucket
    because it's bigger than the spoon or the teacup."

    "No." said the Director, "A normal person would pull the plug. Do you want a
    bed near the window?"


    A Texan, a Frenchman & a Canadian are out riding horses.

    The Texan pulls out an expensive bottle of whiskey, takes a shot, then another, and suddenly throws the bottle in the air, pulls out his gun and shoots the bottle in mid air. The Canadian looks at him and says, "What are you doing?! That was a perfectly good bottle of whiskey!"

    The Texan says, "In Texas, there's plenty of whiskey and bottles are cheap."

    A while later, not wanting to be outdone, the Frenchman pulls out a bottle of champagne, takes a few sips, throws the bottle in the air, pulls out his gun and shoots it. The Canadian can't believe this and says, "What did you do that for? That was an expensive bottle of Champagne!"

    The Frenchman says "In France there's plenty of Champagne and bottles are cheap."

    So a while later the Canadian pulls out a bottle of beer. He opens it, takes a sip, takes another sip, and then chugs the rest. He then puts the bottle back in his saddlebag, pulls out his gun, turns around and shoots the Frenchman.

    The Texan, shocked, says, "Why did you do that?"

    The Canadian says, "Well, in Canada, we have plenty of Frenchmen, but beer bottles are worth 10 cents ."

    Re: Demographics of Our Members

    Who said computing was for nerds, what a fine bunch of people you all sound.

    I am 50 (suger plum fairies, never thought I would think that out loud), degree in engineering (Melbourne, Australia), live in most livable Warrandyte, love mathematics.

    Run a company that aims to provide simple solutions to complex issues - using Excel because no one is scared of it - self taught VBA (so I really know nothing) but get by - I am contiunally amazed at the power of Excel - recently wrote solutions for Sukudo and the 9 letter puzzle of our local paper the AGE

    I would note have enjoyed what I do so much had it not been for Ozgrid!~!!

    Re: If or Select Case?

    Hi guys,

    I reckon this is a great question and one that relates to many facilities within Excel. As Excel is a very powerful tool, it also provides many ways to do the same thing.

    My belief is that 'nest ifs' are very important as part of the learning curve of Excel - get that right in your head and other functions follow. I predominately use 'case statements' now because I try to make all code modular and small; but I started with ifs progressed to elseifs and then to case statements.

    Great question!


    Re: Counting number with two criteria

    Pardon me for seeking further information, the last post also indicates you can count multiple criterias such as


    What I don't understand is the function of the -- in the formula, is it part of Excels array system?


    Re: If Date Format Only

    Three brilliant solutions, thanks heaps, I can use all of them, love the custome function

    If you have seen the film "The Castle" then this will make sense, these solutions are going straight to the pool room (right next to the beer stein!)