Runtime Error 1004

[Former Member]

Guys,

Urgent help required. I am getting "run-time error 1004" programmatic acess to visual basic project is not trusted.......

The error occurs while executing a layout in the planning package in EXCEL. Can some one be helpful in pointing me out in the right direction. So far I have lowered the security for running macros in excel and also enabled "Trust access to Visual Basic", but no use.

Regards

Salman

[Former Member]

Salman,

I also had same issue in the past & i got it fixed in the same manner as you mentioned.

just as a check, make sure that the settings are saved upon re-execution.

Or, exit & login back after saving the settings just to make sure settings are up-to-date.

in any case, there is only 1 SAP note "Note on security settings of Excel in SEM-BPS : 429183" that describes about this error.

Have a look at it & if it's still not helpful, open up a OSS message.

But, in most cases, it's got be something on the front-end.

best of luck.

[Former Member]

thanks hari for the detailed help. I will look at the oss note. BTW can u plz also look at my other post below and try if u can answer.

regards,

salman

[Former Member]

salman,

i answered your other question. have a look at it.

[Former Member]

thanks ever so much.

Regards,

Salman.