Please tell me how to put password in VBA

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
"Amol" wrote in message
ups.com...

Please tell me how to put password in VBA

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

"Paul B" wrote:

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
"Amol" wrote in message
ups.com...

Please tell me how to put password in VBA

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
"Paul Trebbett" wrote in message
...
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

"Paul B" wrote:

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
"Amol" wrote in message
ups.com...

Please tell me how to put password in VBA