activate macro question

  1. W

    Run code if a cell is selected

    I want to activate some code when a particular cell is selected. I found this code below from Teylan in New Zealand posted in 2013. When I put this code in the sheet module it works perfectly. Thankyou Teylan. But instead of cell D4 as the activation cell, I want to use merged cells D4 and D5...
  2. 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...
  3. 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...
  4. 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...
  5. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top