protection not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

randy in nc - 28 Jan 2008 23:06 GMT

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 to this Message

Nigel - 29 Jan 2008 08:32 GMT

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.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

> I have a project... It is not complicated.. but all I want to do is
> protect
[quoted text clipped - 13 lines]
>
> thank you

Reply to this Message

randy in nc - 29 Jan 2008 14:06 GMT

I am using in this version xlsm I have also just saved it as an xlsx. The
older versions that I have used were created on machines with older versions
of excel.. and are xls..

I feel that it should save it, I also tried changing the project name to
check and it would not save it...

What could I be doing wrong...

> Are you saving it as a type xlsm in xl2007 or type xls for previous versions
> of Excel?
[quoted text clipped - 18 lines]
> >
> > thank you

Reply to this Message