| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect marco
I have a file contains some marco which dont want to be read by other person.
How can I set the marco unread? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
protect marco
On 2 Dec, 12:17, Wu wrote:
I have a file contains some marco which dont want to be read by other person. How can I set the marco unread? you need to set a password in the VB projects window. Alt - F11, Tools , VBAproject Properties, Protection and make sure the 'Lock project for viewing' has a tick Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
protect marco
To make it unseeable use
Private Sub mysub() or option private module as the first line in the module Be aware that it is fairly easy for anyone with knowledge to break your password. -- Don Guillett Microsoft MVP Excel SalesAid Software "Steve" wrote in message ... On 2 Dec, 12:17, Wu wrote: I have a file contains some marco which dont want to be read by other person. How can I set the marco unread? you need to set a password in the VB projects window. Alt - F11, Tools , VBAproject Properties, Protection and make sure the 'Lock project for viewing' has a tick Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marco | Excel Discussion (Misc queries) | |||
| Marco Help | Excel Discussion (Misc queries) | |||
| Writing a Marco | Excel Discussion (Misc queries) | |||
| I need some help with a Marco | Excel Discussion (Misc queries) | |||
| Marco | New Users to Excel | |||
Linear Mode
