workbook open close

I have some specific cells locked and others unlocked. When I manually protect the worksheet, I cannot select the locked cells, which is what I am looking for. This is the correct behavior. I have some code that runs when I open a workbook and when I close the workbook. The code basically...

I am running into an interesting scenario with a VBA add-in project. I have a macro that opens up an Excel file, does some stuff, then closes the file. I am running into an issue when this macro is run immediately after someone opens up a blank Excel workbook and has not made any changes to it...

Hi All, I want to copy cells A1:A5 from "book1" into "book2", but if "book2" isn't open, i want the macro to open it, copy the cells into it, then save "book2". I have the below, but it doesn't work because I don't think i'm referencing the workbooks correctly? Both are saved on my desktop...

I have VBA in a workbook that executes a large amount of code when the workbook is opened, under Private Sub Workbook_Open() After executing the code, the workbook stayed open. I run a scheduled task every night that opens the workbook in a new instance of excel, so the code gets executed. The...