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


---
Message posted from http://www.ExcelForum.com/

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

--
Regards,
Tom Ogilvy

"raymondsum" wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

Hello Raymond

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


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/

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.


---
Message posted from http://www.ExcelForum.com/

Colo,

Thank you!

Raymon

--
Message posted from http://www.ExcelForum.com