Results 1 to 6 of 6

Thread: Excel

  1. Jul 23rd, 2001, 08:29 AM #1
    Mark Sreeves
    Mark Sreeves is offline

    Thread Starter
    Frenzied Member Mark Sreeves's Avatar
    Join Date
    Nov 1999
    Location
    UK
    Posts
    1,845

    Excel

    I expect you've seen this before
    it's that old "purity" spread sheet

    What I was wondering is: where is the code in it?

    I'm sure I can't find it!
    Mark
    -------------------
    Reply With Quote Reply With Quote
  2. Mar 1st, 2002, 11:42 AM #2
    SeaHag
    SeaHag is offline
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901
    Thats freeky

    ne1 know?

    Seahag
    Reply With Quote Reply With Quote
  3. Mar 1st, 2002, 11:50 AM #3
    SjR
    SjR is offline
    Hyperactive Member SjR's Avatar
    Join Date
    Jul 2001
    Location
    Birmingham, UK
    Posts
    336
    I'm gonna spoil it for ya

    run this
    VB Code:
    1. Sub main()

    2.  
    3. Sheets("macro2").Visible = True

    4.  
    5. End Sub

    Another satisfied customer
    Reply With Quote Reply With Quote
  4. Mar 1st, 2002, 11:58 AM #4
    Ianpbaker
    Ianpbaker is offline
    Fanatic Member Ianpbaker's Avatar
    Join Date
    Mar 2000
    Location
    Hastings
    Posts
    696
    100% on the drinking score with a total score of 130
    Yeah, well I'm gonna build my own lunar space lander! With blackjack aaaaannd Hookers! Actually, forget the space lander, and the blackjack. Ahhhh forget the whole thing!
    Reply With Quote Reply With Quote
  6. Mar 1st, 2002, 11:58 AM #5
    SjR
    SjR is offline
    Hyperactive Member SjR's Avatar
    Join Date
    Jul 2001
    Location
    Birmingham, UK
    Posts
    336
    better still go
    Format > Sheet > Unhide and select Macro 2
    from the menu.

    Whoever did it didn't even bother to hide it from the menu
    Another satisfied customer
    Reply With Quote Reply With Quote
  7. Mar 1st, 2002, 02:13 PM #6
    SeaHag
    SeaHag is offline
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901
    I have never seen a macro like that before.

    Its written in the sheet itself. How is it triggered.
    I mean When i press the play macrobutton.. i am usually face with options. Like run, jumpinto edit.

    This sheet just starts a macro...

    How is this done?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width