I've created a macro in PowerPoint that opens up an Excel workbook, loops through the sheets in the workbook, creates PowerPoint charts and populates them with the data from the Excel sheets. Just to make it clear, the macro is run from PowerPoint.
I now have the need to make the data...
Hi,
I want after I select slide, copy there charts from excel, I have code as below:
Set wb = ActiveWorkbook
Set ws2 = wb.Worksheets("C2")
Dim newPowerPoint As PowerPoint.Application
Dim activeSlide As PowerPoint.Slide
Dim cht As Excel.ChartObject
Set newPowerPoint = New...
Good day,
In Powerpoint i added a shape and on click i need it to change color. when i go to a new slide i need it to return to the original color set. the macro i have set up is
Sub changecol(oshp As Shape) On Error GoTo errhandler
oshp.Fill.ForeColor.RGB = RGB(25, 200, 0)
Exit Sub...
Hi Guys,
I have created an Addin in powerpoint 2007 and I can see it in ribbon, whenever I execute the addin through ribbon it pops up required coded message then it sends an alert message stating "The macro cannot be found or disabled because of your security settings".
If I run the macro...
I have a macro that pastes charts (as images) from Excel in a new PowerPoint slide by slide.
I had to copy the charts as images so they wouldn't have a link to the Excel data anymore.
For some reason when I past the images in to PowerPoint they are obscurely placed on the slide. I need to...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.