1. R

    VBA- Enable autorun outlining on all password protected worksheets in a workbook

    I am looking for VBA code to enable outlining on all protected worksheets in a workbook. I would like it to autorun on startup and work whether or not the protection has a password or not. Thank you
  2. M

    Automatically print file when cells change

    I have this code that uses a button to print 3 columns of data to a text file. I want the code to run any time cells A2 through D2 change rather than using the button each time. Is there a way to do this? <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant...
  3. S

    autorun macro with vlookup function

    Hi There, I got a little held up on my work to autorun an vlookup function in vba. I want to lookup a value that I created and auto populate in a cell this is the code but it will not work, please help! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(0, 0) = "$B$5" Then...
  4. M

    Stopping ontime method

    I can't seem to stop this. I need a macro that can be called to stop this code. Sub autorun() Application.OnTime ThisWorkBook.Sheets(1).Range("p31").Value, "up"
  5. K

    Trigger running Macro on updating Pivot Table

    Is it possible to trigger a macro to run when I update a pivot table? I am running Excel 2016. I did do a search but can't find any information on this.
  6. M

    Personal.xlsb not closing down with Excel process

    I have a few macros saved into my Personal.xlsb file which work as expected. The problem is that when i close Excel and look in Task Manager there is still at least one Excel.exe running which gradually builds up in memory until it causes the whole system to slow down. Having googled around I...
  7. A

    Using a macro to open a macroenabled file which has autorun but autorun doesn't work

    Hello everyone, I searched the forum and internet but couldn't find the answer I need. I don't know if I found a bug within excel. Here is the story: I am using an excel file (lets say "xlsm1") which has a userform in it (actually I am just letting the user to see the userform) With this...
  8. R

    How to run a macro when editing any cell

    Hi fellas, I really apreciate your help in advance. I need to run a already existing macro (copy and paste values) when editing any cell in a worksheet. Thanks again.
  9. E

    conditional macro auto run

    Hi everyone, im new to xl. im trying to make a stocktake and ordering system. I've made 2 columns for stock in and stock out, that add/subtract from the total shelf stock of each item. My first problem was when adding or taking stock, the value would be + or - again every time another cell was...
  10. D

    QUIZ: Is this possible? If so, how ;)

    Hello, thanks for looking at this for me. I have laid out the scenario as best I can below (apologies for the poor text formatting). I've got a series of individual files (all formatted exactly the same) containing data. These are located in specific directories. I have one consolidation...

Some videos you may like

This Week's Hot Topics