• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel VBA

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Excel VBA

    I've created a combo box on a worksheet and have some VBA on the change event. I don't want the user to see what the code is doing. I managed to turn this option off before but I've forgotten how to do it.
    Could one of you give me some help.
    I also would like some insults as well seeing as it's such an easy thing to do.

    #2
    you can password protect the code project - is that what you're after?


    oh, & you're a right spanner.


    hth

    tl

    Comment


      #3
      Your mother was a hamster, and your father smelled of elderberries!

      Comment


        #4
        Originally posted by thunderlizard
        you can password protect the code project - is that what you're after?


        oh, & you're a right spanner.


        hth

        tl
        I'm afraid not.
        The vba script goes to other worksheets and you can see this happening. I just want it to run and the user doesn't see any of that.

        Comment


          #5
          screenupdating ?

          why could you not google this yourself you tw4t!!!!

          That'll be £250 please.
          McCoy: "Medical men are trained in logic."
          Spock: "Trained? Judging from you, I would have guessed it was trial and error."

          Comment


            #6
            Originally posted by lilelvis2000
            screenupdating ?

            why could you not google this yourself you tw4t!!!!

            That'll be £250 please.
            That's the baby. Thanks.
            Cheque is in the post.

            P.S you geek

            Comment

            Working...
            X