Ducklings23
New Member
- Joined
- Mar 11, 2020
- Messages
- 20
- Office Version
- 2016
- Platform
- Windows
Hi all. I've got some code but it's not working exactly as I intended. I'm trying to create a button within a cell in my "Change Log" worksheet that when clicked takes a screenshot of specific cells in the "Summaries" worksheet, storing the screenshot in a third sheet "SummaryScreenshots". I then want to button to move down into the next row in "Change Log", and for the whole process to be repeatable, with all the screenshots saved in "SummaryScreenshots".
If possible, I'd also like each screenshot to generate a date/time stamp, so that they are unique and that they get stored in "SummaryScreenshots" one after the other. These last two requirements aren't within my current code yet, so any help with that additional functionality would be appreciated. Currently the code creates a button in the right sheet and takes the correct screenshot, storing it in the right place. But the button doesn't move afterwards as intended.
If possible, I'd also like each screenshot to generate a date/time stamp, so that they are unique and that they get stored in "SummaryScreenshots" one after the other. These last two requirements aren't within my current code yet, so any help with that additional functionality would be appreciated. Currently the code creates a button in the right sheet and takes the correct screenshot, storing it in the right place. But the button doesn't move afterwards as intended.