How to add a macro with password protection

  • Thread starter Thread starter PleaseHelpMe
  • Start date Start date
P

PleaseHelpMe

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Unlock Excel Workbook protected by MACRO Password 6
Problem in adding macro to ribbon through Add-in 7
including macro in protected worksheet 2
Macros and Password Protection 6
Open password protected file with macros 2
Novice - using macro to protect with password 10
How to call Excel add-in macro from a button… 1
not able to enable macro in password protected .xlsm workbook. 2

Back
Top