Run-Time error '9' Subscript out of range only when I launch excel

[Vurog]

Hey,

So I've tried searching everywhere for a solution to this and can't manage to find anything.

I work at a medium sized company and one of our end users gets this error when he launches excel (doesn't matter which workbook he tried to open), the "continue" and "debug" icons are greyed out.

After pressing "End" everything works just normally.

We're not using any macros/scripts or nothing.

any help and suggestions would be highly appreciated.

Thanks

 

[Fluff]

Check the startup folder, I suspect that xl is loading a macro enabled workbook, which has a workbook open event

 

[Rick Rothstein]

I work at a medium sized company and one of our end users gets this error when he launches excel (doesn't matter which workbook he tried to open), the "continue" and "debug" icons are greyed out.

After pressing "End" everything works just normally.

We're not using any macros/scripts or nothing.

If this is happening to one employee only, then my guess is that the employee has a Personal workbook (personal.xlsb) attached to his copy of Excel and it has a event code procedure that is running when the workbook is opened. I don't use a Personal workbook myself, but I believe it can do that. The error he is getting means one of the functions or subroutines being called from the event procedure is missing an argument. Obviously, if I am right, we cannot help any more than this, but hopefully that will narrow down your search for the problem.

 

[MrKowz]

Welcome to the forums!

It sounds like there is a password-protected addin or workbook that is loading with Excel. Try disabling all add-ins and check the XLSTART folder to see if that has anything in it (Location should be C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart).

You can also check the VBA Editor (Alt+F11) and check the Projects pane to see if there are any workbooks.

Hope that helps!

 

[Vurog]

Hey!

Thanks a bunch! Just checked the XLStart folder and there was indeed a password-protected file.
Deleting that solved the issue, not seeing the error anymore!

Once again, Thanks!

 

[MrKowz]

Hey!

Thanks a bunch! Just checked the XLStart folder and there was indeed a password-protected file.
Deleting that solved the issue, not seeing the error anymore!

Once again, Thanks!

Happy we were able to help out - have a good weekend!