Excel VBA code runs by itself when stepping through

1000 Views Asked by At

Sorry if this is a duplicate, however I doubt that, as I've been Googling for an hour and no search hits even come close to what i'm looking for.

My macro is run from Excel, it opens a PowerPoint presentation from a Sharepoint and handles Excels that are embedded in the pptx.

My problem is that whenever I am stepping through the code, all lines are executed one-by-one as they should, but when I run the line .Range("A" & i).Hyperlinks(1).Follow (this opens the pptx), the code just runs all the way to the end automatically. Keep in mind, I am stepping through - and I am not accidentally hitting F5, or anything like that.

I'm suspecting it's either the hyperlink, or the fact that I am handling PowerPoint from Excel, but can't find the reason.

I am experiencing an issue and want to find where the code goes wrong, but can't as it just "runs away" after following the hyperlink.

0

There are 0 best solutions below