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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...