trigger macros

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...