Hi
I am using VBA to populate data to an excel template.
 So i called the sheet
using

 Dim SalaryBook As Excel.Workbook
Set SalaryBook = GetObject("C:\WINDOWS\Temp\Carbon.xls", "Excel.Sheet.8")

My problem is, since there is a macro in the excel sheet,
the above call will open a model dialoge box from EXCEL with options enable macro,disable macro and more info option.

My problem is that i can not click on this option button in the above dialoge box.
Some how it is in the back ground only.
I think I need to make the excel visible to click it?
In debug mode i can click on it.
But in run mode i can not click on it.
Help me.

One way to get rid of this messages is to set the Macro Security level to "low".

I use to open excel workbooks this way:

Dim oApp As New Excel.Application
    oApp.Workbooks.Open "..path here ..", False
    oApp.Visible = True

One problem could be that the new excel application may not load the add-ins installed, so you may have to add a line like:

oApp.RegisterXLL ...

Does it solve your problem?
Mihai

Thanks for the reply,
I tried to reduce the macro security.
it is not saving it. going back to medium radio button option, even if i selected low or high.

I setted like this in a new Excel sheet.
my version is office 2003.

On the Tools menu, click Options.
Click the Security tab.
Under Macro Security, click Macro Security.
Click the Security Level tab, and then select the security level you want to use

any idea?

Changing the security level it's working for me, but I use Office 2000 package.

Try the second method, described yesterday.

Good Luck!
Mihai