How to Protect MACRO with Password

  • Thread starter Thread starter Amol
  • Start date Start date
Amol, to protect the VBA project? if so try this, if this is not what you
want post back

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is at the top-left of the spreadsheet
this will open the VBA editor, in Project Explorer right click on your
workbook name, if you don't see it press CTRL + r to open the Project
Explorer then select VBA project properties, protection, check lock project
for viewing and set a password. Press Alt and Q to close this window and go
back to your workbook and save and close the file. Be aware that this
password can be broken by third party software


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Do you know if there's a problem with this in Excel 2007? Unfortunately
we've only one machine running '07 in the office to use as a test-bed, but...

When the VBA project is password protected (to keep those very hidden sheets
very hidden) on this one PC and saved, when re-opened on the same PC *even
with a different user logged on, and after a reboot* the password protection
is not in place. If it was originally saved as an '03 workbook, the password
functions correctly when opened on a different PC running Excel '03.
However, if saved as an '07 workbook then Microsoft's own conversion utility
strips this password when opened on a PC running '03.

Known glitch or just a weird PC? And are there any fixes available?

Thanks
 
Never ever rely on password protection on any Excel object.

Everything can be broken into.

Use AddIns.
 
I don't have Excel 2007 so I can't say, Sorry

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
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
Novice - using macro to protect with password 10
Open password protected file with macros 2
Excel Protection 2
including macro in protected worksheet 2
How do i password protect my VB Code from users 2
Knowing is a workbook's VBA project has password or not 2
How do I save a paswd protected .xlsm file containing old macros 7

Back
Top