activate macro question

  1. C

    Error 9: Subscript out of range

    The following is just part of my code. i am getting an Error 9: Subscript out of range. I've tried a few things in order to correct this but nothing seems to change it. r = 2 c = 2 i = 2 LastRowNumber = xlLastRow(Sheets("Data")) Do While...
  2. U

    Actions based on an activated cell

    I built a function that will pull options from the imported data. Cell B2 will always have the first option box and if there are 25 options they will continue down to B26. The next set of options will be from F2 to F26 then columns J and N depending on how many options there are. First: How do...
  3. A

    Macro To Activate Window / Workbook

    Hi There I am new to writing macros and having a prolem getting excel to activate a window. Background: - Excel 2007, Windows XP I have one file called NEW PB SPREADSHEET 10-11.xlsm with multiple tabs. I want the user to click a button that will invoke the macro. The macro presents the user...
  4. F

    Ask every user if he wants to activate macros.

    What would be the code in order Excel asks to every user if he wants to activate macros ? I still know it is possible to configure it un Tools, Security, but more than 50 users in all over the world will use my file. It's impossible the 50 users have the macros activated and I cannot ask to...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top