Update PowerPoint Automatically when SpreadSheet is Changed

Hi,

I am new to VBA and I'm trying to code so that any changes made to Excel document will automatically change in PowerPoint. I have Copied and Pasted Special link so that its connected but when ever a change is made in Excel in powerpoint I get a pop up box saying I need to press update. But I want to bypass the pop up update box and have it so that powerpoint automatically updates when I change something in Excel.

This is the code I have so far. I don't know if it's right or if I am on the right track as I get a compile error saying I need a End with.

Please Login or Register  to view this content.

Any tips is greatly appreciated.

Thanks in advance!!!

Hi, Anne.Gomes008,

welcome to ExcelFDorum. Perhaps you should have a read at the Forum rules again as you would need to change the Thread Titel to a more search friendly one (#1) and add code tags to your procedure (#3).

Ciao,
Holger

Thanks Holger.

Anne,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.

Please follow post 2 and edit your thread title - go to Edit post on your 1st post and click on Go Advanced and then change your thread title.

Hi, Anne,

the end of the code causes the trouble you mention.

Please Login or Register  to view this content.

needs an End With but both Variables have not been dimmed nor filled within the procedure. Maybe you should adapt the code to read

Please Login or Register  to view this content.

which can´t be tested from my side as the test macro isn´t available.

Ciao,
Holger