Excel in place with macro auto run

[aromalr]

Hi,

I tried SAP Excel in place functionality with some macro.It is working fine when I execute it manually using macro shortcut/Macro run manually.

Is it possible to auto run a macro automatically when I select excel in place functionally with a custom layout . I tried to put my code in Auto_Open method. Its works outside SAP but doesn't work inside SAP. Is there any security settings inside SAP which prevent auto run of SAP macro?

Regards

Aromal R

[aromalr]

thank you scriptman,

I have already tried this.It will not work because by that time objects will not be available. I got a run time error.

I tried SheetChange method and its for my scenario.

Closing this thread .

Regards

Aromal R

[script_man]

Hi Aromal,

maybe the following thread of interest to you:

Regards,

ScriptMan