View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_532_] joel[_532_] is offline
external usenet poster
 
Posts: 1
Default Office 2003 macro won't run in Office 2007


Check if the cells in the workbook are selected to see if the problem si
in excel or powerpoint. I wouldmake the following change

from
'EXCEL CODE
Sheets("TablesforPP").Select
range("a2").Select
Selection.Copy


to
with Thisworkbook
'EXCEL CODE
Sheets("TablesforPP").range("a2").Copy
end with


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170126

Microsoft Office Help