I have a code that pastes a selected range directly into an active powerpoint slide in the form of a picture. I would like to have the button, titled go, run through a series where it automatically selects each of the 4 tables ( in the excel workbook included) and pastes them on different slides by activating them through slide names.
Please Login or Register to view this content.
Last edited by K_N; 03-20-2018 at 11:19 AM.
The red numbers in the code below are the slide index numbers that each table is pasted to. Change them to suit.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Worked Like a charm, thank you! Note: For those attempting to do this as well. Your slides may have been moved during the creation process so their assigned number may not be intuitive. There are plenty of threads that discuss how to find the correct slide name or number.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks