I can do parts of this separately, but I can't seem to figure out how to get it all together, I've recorded a few macros that do parts of this badly, but I can't show any code that would be helpful.

I'm trying to program a macro that

1) Opens a dialog box that allows the user to choose a folder and highlight multiple JPEGS
2) After you choose your photos, get a message box that asks if you've chosen all the photos you need, if not choose more
3) The photos are inserted into the worksheet, the size of an entire page, and one photo per page (in other words, each photo would be size 8.5X11", and not cascading. This is so that when the user hits "Print", they don't have to spend hours re-arranging and sizing hundreds of photos)

Thank you!