Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rendezvous

  1. rendezvous

    Protecting Files from Saving/Downloading from the Web

    Is there a way to post an excel file on a web site so the users can open and enter info in the file, but not save or download it. Alternatively, should I disable the "Save" command within excel through VBA? If so, how is this done? This will get around the issue of saving. In a...
  2. rendezvous

    Protecting Excel File on Web

    Is there a way to post an excel file on a web site so the users can open the file, (do their stuff), but not save or download it. I want the users to be able to see and enter info, but not save or download. thanks
  3. rendezvous

    Keeping the value of a variable outside of the subroutine

    In Excel, I have a selection of 4 radio buttons. When I click one of the 4 buttons, I am trying to find and store a value that the radio button has been selected, but once the subroutine has ended the value of the variables is reset. How can I keep the value of the variable, is there a better...
  4. rendezvous

    Calling a macro from within a macro

    If I have 2 macros, TEST and TEST2, how can I call TEST2 from within the first macro TEST? Sub TEST() ActiveCell.FormulaR1C1 = "SAY HELLO" Range("A2").Select End Sub Sub TEST2() ActiveCell.FormulaR1C1 = "SAY GOODBYE" Range("A3").Select...
  5. rendezvous

    Automatically executing a subroutine/macro when opening a file

    How do you get an excel file to automatically launch a macro as soon as the file is opened? thanks

Part and Inventory Search

Back
Top