Get instant live expert help on I need help with vba workbooks open
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have 2 workbooks open in Excel. Both contain VBA codes. If I close one, should the "Workbook_Activate" event trigger on the other?
Solved by G. H. in 12 mins
I have a VBA that includes a running clock. I locked this VBA and have it set up to include my password and so the macro executes when I open the file. The worksheet is titled "PSC Dashboard". The problem is I cannot have any other worksheet/workbook open while it's running. The Macro also runs in the unrelated workbooks/worksheets that are open. I would like to keep PSC Dashboard open while I have other workbooks open. I only want this macro to run while PSC Dashboard is open. Thank you, Eugene
Solved by M. Y. in 15 mins
I need help editing my macro to be able to work in different workbooks. Currently, it only points to the original file that the macro was created in and I don't want to open VBA to edit the file name each time.
Solved by F. F. in 13 mins
I need help to compare two workbooks (and every worksheet) using highlighting. VBA would be great.
Solved by F. A. in 30 mins
when I try to open one workbook I get multiple workbooks opening
Solved by F. W. in 27 mins