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