Okay...I got it.

Another question re. references. I will be putting the Excel workbook with
the macros on a sharepoint server for multiple users to access. And possibly
individuals will have copies on their own machines. Will my Excel/powerpoint
macros still work or does the VBA reference also need to be set on the
server/other machines?

Thanks for any insight!

"Nickis" wrote:

What menu do I go to? I don't see a menu.

"Joel" wrote:

You can't set a reference while a macro is reunning. go to menu VBA Run -
Reset. the go and set the reference.

"Nickis" wrote:

I am trying to write code in Excel to control Powerpoint. I located some
information that said to enable Excel to interact with other applications a
reference has to be set to the other application's object library. The info
said this could be done "in the Visual Basic Editor (VBE), select
References... from the Tools menu".

However, my "references" is greyed out so that I can't select it.

1) Not sure why?
2) Is this the only way I can get Excel to Control Powerpoint?

All I'm trying to do is a simple copy paste between applications, problem is
there's a lot of back and forth and I can't execute the Powerpoint code
automatically (from what I've read online so far), so I think controlling
from Excel is my best option.

Thanks for any insight.

Nicki