trigger macros

  1. K

    Trigger Auto Hide / Show Rows in other Sheets

    Good Day to you all, Newbie here, looking for some advice 😊. I have a spreadsheet linked here (hope it works) Its my works training record for different areas. I could split it down to different positions but I'm sure there's a way to keep it all together. I have browsed through to see if i...
  2. A

    Check if file is password protected

    Hi everyone! I'm looking for a way to check if an Excel file is password protected. If so, VBA should open it with the "default" office password. This should happen anytime a file is opened by any means (i.e. from Windows Explorer, and not just through another piece of code in another Excel) I...
  3. T

    How to trigger a macro using a value that's in another tab in the same workbook

    Hello all youVBA geniuses, Need some help with a doozy of a code here. I've got this pieceof script that hides rows in a tab called "Lab Tests_Plants". Youenter a number in cell D15 and it shows you the corresponding amount of rows.Cell E15 = "#" and E16 = "<=" to lay out parameters. Private...
  4. R

    Trigger macro from outside excel environment

    Is it possible to trigger macro from outside excel environment? My requirement is to take screenshot of citrix application when we click on it.
  5. R

    Trigger when another file is opened

    Hi, First thread so sorry if I don't put my query over fully. I need a method of recognising when a file is opened so I can then automatically save it to disk. Reason for this is that I recieve files via email hyperlinks each day which I open and then have to save via Save As options. This...
  6. C

    Get Excel to trigger a macro when user protects or unprotects worksheet

    I don't know if this is possible, but is there a way to get Excel to trigger a macro whenever a user either protects or unprotects a certain worksheet within a workbook via Protect/Unprotect Sheet. Ideally, I would like to be able to trigger one macro if the worksheet is protected and a...
  7. R

    Macro to copy from Sh1 (triggered by an entry), paste in Sh2 but also integrating it into existing code

    Hi: I need help with writing a new macro and integrating it into some existing code. My existing code works well for creating an auto hyperlink, from one sheet to another, triggerered by a dropdown value in Sh1 column K. I'm trying to add vba code to have the same trigger do a copy of cells...
  8. U

    What is the trigger for password protecting a worksheet.

    I have worksheet one that I want to be read only for everyone but the second worksheet is superfluous I need to hide it. I password protect the first sheet everyday and I would like to know the code that will detect when the sheet is protected so it can hide the second sheet and when the first...
  9. 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...
  10. U

    Trigger a macro by clicking in column B

    I have been righting macros for years but I have never written one with a trigger. I don't even know what to search for. FUNCTION NEEDED When some clicks on a cell in column B ° If the cell is blank I need a check mark and then to run the macro I have written. ° If the cell is not blank I need...
  11. T

    VBA - Trigger a macro when ANY cell in column A is selected

    I haven't found exactly what I need on the boards, so hope someone can help. I have a macro that refreshes a dataset from SQL, then creates a new sheet with some of that data placed and formatted as desired. My issue is that after that macro runs, I need to run another macro when any cell in...
  12. J

    Trigger Macros on ComboBox Selection

    Hello Everyone, Please help me to trigger a macro according to the selection in the ComboBox. Details: ComboBox Values: Day Shift, Night Shift Macro Names: DayShift, NightShift Expected Result: When "Day Shift" is selected, the active cell colour should go orange via macro "DayShift". When...

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