| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect macro code from viewing/editing
In older versions of EXCEL I was able to password protect
my VBA code so that users couldn't access to read/copy/edit. I can not find a way to do this in EXCEL 2002. Any help would be appreciated. k |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect macro code from viewing/editing
hi keith
very easy go to EXTRAS - Properties of VBA project - protection kind regards from AUSTRIA (graz) mario "Keith" schrieb im Newsbeitrag ... In older versions of EXCEL I was able to password protect my VBA code so that users couldn't access to read/copy/edit. I can not find a way to do this in EXCEL 2002. Any help would be appreciated. k |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect macro code from viewing/editing
Mario's answer didn't get me there. Anyone else care to
chime in?? keith -----Original Message----- In older versions of EXCEL I was able to password protect my VBA code so that users couldn't access to read/copy/edit. I can not find a way to do this in EXCEL 2002. Any help would be appreciated. k . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect macro code from viewing/editing
Keith,
In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then the Protection tab. There, check the "Lock project for viewing" option and give it a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "keith" wrote in message ... Mario's answer didn't get me there. Anyone else care to chime in?? keith -----Original Message----- In older versions of EXCEL I was able to password protect my VBA code so that users couldn't access to read/copy/edit. I can not find a way to do this in EXCEL 2002. Any help would be appreciated. k . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect macro code from viewing/editing
I had tried that before and can still go right to the
code from the EXCEL workbook. Any other thoughts Keith -----Original Message----- Keith, In the VBA Editor, go to the Tools menu, choose VBA Project Properties, then the Protection tab. There, check the "Lock project for viewing" option and give it a password. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "keith" wrote in message ... Mario's answer didn't get me there. Anyone else care to chime in?? keith -----Original Message----- In older versions of EXCEL I was able to password protect my VBA code so that users couldn't access to read/copy/edit. I can not find a way to do this in EXCEL 2002. Any help would be appreciated. k . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect macro code from viewing/editing
You'll have access to the project until you close and reopen the
workbook. In article , "Keith" wrote: I had tried that before and can still go right to the code from the EXCEL workbook. Any other thoughts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password protect sheet from viewing | Excel Worksheet Functions | |||
| Password protect from viewing | Excel Discussion (Misc queries) | |||
| Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
| viewing a header/footer while editing | Excel Discussion (Misc queries) | |||
| Protect data in cell from viewing it | Excel Programming | |||
![Keith[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
