ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Dispaly Box (https://www.excelbanter.com/excel-programming/285274-macro-dispaly-box.html)

raymondsum[_13_]

Macro Dispaly Box
 
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/


Tom Ogilvy

Macro Dispaly Box
 
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/




Colo[_22_]

Macro Dispaly Box
 
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/


raymondsum[_14_]

Macro Dispaly Box
 
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/


Colo[_25_]

Macro Dispaly Box
 
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/


raymondsum[_15_]

Macro Dispaly Box
 
Colo,

Thank you!

Raymon

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



All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com