Thread
:
protection not working
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
protection not working
Are you saving it as a type xlsm in xl2007 or type xls for previous versions
of Excel?
Both these options allow the
VB
project to be locked from viewing.
--
Regards,
Nigel
"randy in nc" <randy in
wrote in message
...
I have a project... It is not complicated.. but all I want to do is
protect
the project. I do not want anyone to be able with ease to view some sheets
I
have "very Hidden"
So I have gon to tools, vba project propeties, protection tab. and have
selected "lock project for viewing" and entered my passwords, saved and
closed excel...
When I return all is visible, it is like I never protected it at all...
The same thing works fine in two older versions of excel...
Am I doing something wrong or is the something wrong with excel 2007
thank you
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]