Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a macro with password protection
Hello
I am creating an excel file from vb 6.0. I can add a macro with n problem, what I would like to do is add password proction to the macro Please help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a macro with password protection
Checkout "how to unprotect a passwo. by Paul D just below
-----Original Message----- Hello I am creating an excel file from vb 6.0. I can add a macro with no problem, what I would like to do is add password proction to the macro. Please help! --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a macro with password protection
Open up the VBA Editor and click on the project in the "Project
Explorer" (Ctrl+R" if it's not already open) . The project will have a name like VBAProject(Book1) or something like that. On the main menu go to Tools-VBAProject Properties (This will change if you changed the name of your project, but it will be towards the bottom of the menu and it will say "Properties"). When you do that a window pops up with two tabs "General" and Protection". You want "Protection"... duh... Click the checkbox that says lock project for viewing and enter a password in the fields provided on the bottom of the window. After you've done this you will not notice any difference until you close the project and (try to) re-open it. - Pikus --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
password protection macro - HELP???? | Excel Discussion (Misc queries) | |||
Clear Macro & Password Protection | Excel Discussion (Misc queries) | |||
develop a macro which takes password protection on and off | Excel Discussion (Misc queries) |