How to inspect my own project code with VBA

[AEberli]

I want to inspect my own code for keywords and do something. In older threads I have found the some identical solutions for this, but it doesn't work for me, I get always the error 1004 and I have no idea.

Please Login or Register  to view this content.

2019-02-23_13-34-07.jpg

[Haluk]

I am not sure what the error message is about because I don't know German language.

But, you have to apply some settings and add a reference to your project. Can you look to what I have written in the below link in post #2 ?

https://www.excelforum.com/excel-pro...ml#post5068063

[AEberli]

Hello Haluk

Thank you, with your information I could derive what to do, but it was guessing with trial and error.


1) I have found the Reference file, but the name ist not full visible in the selection pane,
so I had to scroll right to see what it means


2019-02-23_20-48-39.jpg


I did not find a Trust Center Button in VBA for MAC, but I have found a menu entry in the Settings of Excel,
but here also was the German translation of the text not full readable, so I gave it a try.


2019-02-23_20-46-52.jpg


After this I could compile and run the Macro