Get instant live expert help on I need help with excel run macro on open

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

After the macro run Left click stops working on windows 10
Solved by E. Y. in 12 mins
Hi, I am calling an excel sheet from matlab, and while i have the sheet open it is running a macro. This macro then tries to activate other workbooks, but is getting a subscript out of range error because it only knows about this excel sheet. When I open the excel sheet manually and run the macro it works fine. I can't figure out a way to fix this - we basically need to make the excel sheet called from matlab aware of other workbooks.
Solved by Z. Y. in 26 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 can't open an Excel spreadsheet (.xls) from a statistical website. The message says, "This app can't run on your PC". I need to open the Excel file and save it to my computer. I have run "Repair" and it doesn't seem to help.
Solved by X. U. in 23 mins
Macros in Exell spreadsheets. On my new computer "Short cut" keys on macros don't work on existing Excel workbooks. I have to run them through the macro dialogue box.
Solved by A. F. in 15 mins