ebcopystop
New Member
- Joined
- Jan 5, 2022
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
I have a spreadsheet with tons of images and have to demo said spreadsheet to clients. Instead of scrolling and scrolling and scrolling, is there a way to click a button, or use a dropdown to change (load/remove/replace) and image? I would prefer to load the image from my desktop, rather than have a separate spreadsheet with all images in it. My top three ideal scenarios would be:
1. change the image just by clicking on it
2. create multiple shapes (buttons) that when clicked, make an image appear (preferably not the show/hide method because I would like multiple images to appear in the same cell but at different times)
3. Use a dropdown box and have the image appear/change based on what is selected
Basically, I would really like to avoid scrolling. Is this possible?
1. change the image just by clicking on it
2. create multiple shapes (buttons) that when clicked, make an image appear (preferably not the show/hide method because I would like multiple images to appear in the same cell but at different times)
3. Use a dropdown box and have the image appear/change based on what is selected
Basically, I would really like to avoid scrolling. Is this possible?