Macro Dispaly Box

[raymondsum]

When i open the file having Macro, it will show a Display Box (Macros
contains .... lose some functionality).

How can i hide the Box?

Thanks

Raymond

 

[Tom Ogilvy]

I don't believe you can unless you want to set security to low.

 

[Colo]

Hello Raymond

Changing security as low makes it possible. But you have to care if the
code has been coming from the place trustable.

 

[raymondsum]

Colo,

Thank you for your reply.

If i could not hide the 'Display Box' , then the users knew this file
having 'Macro' designed by me. They will press 'Alt F11' to view or
edit my program.

How could i hide the details of macro if the security setting up by
users is high or medium?

Thanks in advance.

Raymond

 

[Colo]

Hi Raymond,

Plase have a look at VBE(Visual Basic Editor) then right click your
VBProject in the Project window.
Select Property(E), you can protect your VBProject with the PASSWORD at
there.

 

[raymondsum]

Colo,

Thank you!

Raymon