autorun

Hi All I'm a novice and looking for help to fix and resolve this. I thought it would be straight forward but I've been going around in circles to get it to work. I have sheet1 with check boxes (across columns) that informs sheet2 rows if they are checked (True) or un-checked (False). On sheet2...

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

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

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

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"

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.

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

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

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.

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

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