Problem: I have a lock button (toggle button) on my custom ribbon. Basically "lock and unlock" the "Aspect ratio" of the text box.
Also i wanted few points to cover while preparing it - -
I wanted to run the event on powerpoint, whenever I select the single or multiple text...
Hi,
I created SmartArt in Excel that links to some of the formulas I have in a cell. I'm trying to add it to a PowerPoint presentation where I have a lot of linked charts and graphs. For some reason, I can't do a Paste Special paste as Link for the Smart Art. I've tried changing the smart art...
Hello,
I do not have much knowledge in VBA programming but would like to automate a repetitive task that I am doing every week.
I need to copy a range of cells (horizontal/vertical range) with its font color from Excel and then paste them into PowerPoint Text boxes.
I am currently manually...
Greetings,
I've written a macro that creates PowerPoint charts from data in an Excel workbook.
It is nearly functional, except for a Method ‘Range’ of object ‘_Worksheet’ failed error message.
The macro is run in a PowerPoint instance with no slides. It creates the correct PowerPoint...
Hi guys,
I've made a PP presentation with numerous charts. To make the monthly updates run smoothly, I've created dynamic references to the input vectors of these charts - you know, offset(,,,,counta()) and so forth. Then I paste the charts to PP, choosing the 'link data' option and everything...
Hi -
I have a macro that opens a powerpoint presentation and updates linked graphs. I was able to figure out how to get the VBA to save and close the presentation, but because this is a weekly report, I was hoping to be able to save a new copy under a different name. I've tried a number of...
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...
Hi,
I'm adding empty slide. Then I want to set Template (slide 6 from 4x3_Cool_Template.potx). But I dont know how to use it?
newPowerPoint.ActivePresentation.Slides.Add newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutBlanknewPowerPoint.ActiveWindow.View.GotoSlide...
Hi,
I want to copy chart from excel to powerpoint and paste as image:
[code]
Dim wb As Workbook
Dim ws2 As Worksheet
Set wb = ActiveWorkbook
Set ws2 = wb.Worksheets("C2")
Dim newPowerPoint As PowerPoint.Application
Dim activeSlide As PowerPoint.Slide
Set newPowerPoint = New...
Hello,
First-time poster with a rather time-sensitive question. Some coding familiarity, but not specifically with VBA, so I keep tripping on syntax. Been banging my head against this for hours, so any pointers are greatly appreciated!
So I'm trying to export a large table from excel 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.