OPen workbook without executing vba

[juriemagic]

Hi everyone,

I have a workbook that contains rather complicated vba on all sheets. 5 Sheets. I am trying to add a sheet, but vba does not let me. I get an Excel error that says:

"That command cannot be used on multiple selections". Even if I press left shift while opening the workbook, it ignores that and vba still executes. I also disabled macros in Excel, but once again, the workbook ignores that and all vba still work. Any help please....

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[juriemagic]

Thank you, I managed. What I did was click on the sheet tab, press control, and drag to the right. I cannot remember if I tried this previously, but it worked now. Thank you for your time.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.