cancel
Showing results for 
Search instead for 
Did you mean: 

How to save a VBScript

Former Member
0 Kudos

Hello Guru:

In the planning layout, in the 3rd step of the definition, I wrote a VBScript to change the value of a cell.

When I tried to save it, there is a popup says: There is a problem with the digital cerficate. The VBA project could not be signed.

And then I click save again, the popup is not there anymore.

But when I reopen the layout, the vbscript is not there.

How to deal with it? I tried many time. It is killing me.

Thank you very much.

Best regards,

Eric

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Continuation to the above checks I also suggest you to check your macro setting. Before writing any macro, In the layout builder (Change layout)3 rd screen you have to click on the VBA Macro setting and select at least one option like Modul1.SAPAfterDataPut (or) Modul1.SAPBeforeDataGet. Then you have go to VBA Editor and write Code and then save. It will save your code.

Hope this helps.

Regards,

Srisha

Former Member
0 Kudos

Have you tried changing the security setting to medium.

Follow the path Tools-Macros-Security Setting.

Some more things about digital certification and security

http://www.microsoft.com/technet/prodtechnol/office/office2000/maintain/security/vbamacro.mspx

Regs

Gopi

Assign points if it helps...