macro not working properly until vb editor is opened and closed again

I have written some code to generate a ppt. from some excel data. the code is run by pressing a command button in excel. ppt then fires up in the background, generates the ppt. and then displays a splash screen with a button to 'view' the ppt.
When this button is pressed I want the macro to switch windows from excel to powerpoint. (alt + tab in effect).

All the code runs fine however, the last line where powerpoint should be brought to the front just seems to do nothing. If however I then open the visual basic editor, click in the code window and then close it all again, it runs completely differently.

I have attached a file which displays the problem on my machine & others on the network i''ve tested it with.

Someone on here tried it yesterday for me and said it worked fine for him, however he wasnt able to use a share screen app to see the problem in action on my pc.

Hope someone is able to help,

Freddie

Test.xlsm

hi, freddiethomas, try to change CommandButton1_Click code responsible for showing PPT to the following. The amended line is underlined

Please Login or Register  to view this content.

Still no joy watersev

Any chance I can show you the issue in action?

your initial file showed same issue where PPT do not become active after clicking View button. The posted file with the above mentioned small change works OK on my side.

Still no joy for me on your file, did you try saving closing ppt & excel, reopening the file and then running it again?

Thanks for the suggestion.

yes, I did it a couple of times, everything works as expected

Any ideas why it doesn't on my PC? Or any others in the office? is there a setting I might need to check/uncheck? or a particular ref library I need active?

Is there anyone with whom I can screen share so I can show the problem?

could you please try this for SplashScreen3:

Please Login or Register  to view this content.

It actually does not solve the problem, it omits it and provides result you need

:D super, thank you very much! I should have thought to work at the problem the other way round.

Thanks again for your patience watersev

though we have not found the problem root but at least achived the result you want