View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Carlos Correia Carlos Correia is offline
external usenet poster
 
Posts: 7
Default Excel 2007 - Secure workbook with password

Hi again:

I'm from Portugal, maybe I'm not making myself clear with the subject, sorry!

I'll try to explain:

In Excel 2003 we can secure the entire file to br protected with a password
going trhought the menu Tools Options Security tab and the option 'Password
to open'.

It's something similar to this. My Excel 2003 is in Portuguese so I'm trying
to translate it.

But now, with Excel 2007, I can't find that option.

Do you know were it is?

Regards

Thanks for the attention

--
Carlos Alberto Eusébio Correia


"Bob Phillips" wrote:

You asked how to protect the sheet, so that is whata I gave you.

If you ACTUALLY want the workbook, Review TabChanges GroupProtect
Workbook.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Carlos Correia" wrote in message
...
Thanks for the post,

But the only options that I get a
Protect Sheet...
Lock
Cells...

That way I can't protect the workbook from being opened from a person
without knowing the password.

The thing is, I want to prevent the workbook to be seen from another
peorson
without knowing the password to open the workbook... where can I find that
option on Excel 2007?

Regards

--
Carlos Alberto Eusébio Correia


"Bob Phillips" wrote:

Select the Home tab from the Ribbon, and towards the right edge there is
a
group called Cells with the Format option on there. Click the Formt
dropdown, and you will see Protection at the foot of that menu.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Carlos Correia" wrote in message
...
Hi:

With the changes in the layout of the new version of Excel, I can't
find
the
place to protect the opening of the worksheet with a password. I tryed
to
look but can't find it!

Can anywone help me?

Thanks for the attention,

--
Carlos Alberto Eusébio Correia