How to create a slideshow in Excel ?

**jasond1992** · 11-04-2015, 03:05 AM

Hi, is it possible or does anyone know how, to store images within Excel and have the images displayed as a slideshow on the front page (tab) when the spreadsheet is opened? I only want to use Excel (no Power Point or jpeg references to a folder) it has to be stand alone. VBA is ok. My task is to have a spreadsheet that when opened runs a VBA script that shows a series of pictures in increasing speed to a final picture, kind of like a flash intro on a web site. Is there any way of doing this with VBA that does not use external files, add-onss or other software packages?
Thanks Guy

**Kaper** · 11-04-2015, 05:14 AM

One of simple methods (may be just as a starting point).
Create hidden sheet (ose VB editor to change visibility - it is set to very hidden, so cannot be shown with unhide from worksheet interface) with pictures to be used as "slides".
In ThisWorkbook code insert workbook open event handler:

Please Login or Register  to view this content.

note that I:
hardcoded here number of slides,
first is visible for 4 seconds, next 3, 2, and last one just for 1 second
used simplest method of just copying pictures

**jasond1992** · 11-05-2015, 08:37 PM

Nice Sir your Great, Can i Ask how to see the hidden sheet how did you do to hide that and when i go in format to unhide it i cant ? and the picture sir how to resize and rename it in 1 to 4 ??