Amo

Just a head's up to prevent any confusion.

Vista is an operating system and has nothing to do with MS Office or Excel.

What you mean is "protect.xls(Excel 2007)"


Gord Dibben MS Excel MVP

On Thu, 16 Oct 2008 04:52:02 -0700, Arno
wrote:

Could you please also tell me what I have to select to apply the protection
to the whole workbook? Thank you !!



"The Code Cage Team" wrote:

By default the protect sheet is not set up to allow the use of autofilter.
when you apply protection to the sheet when the dialog box opens for your
password, scroll down to the bottom and you will see a "Use Autofilter" box,
just check this.

Regards,
The Code Cage Team
www.thecodecage.com/forumz

"Arno" wrote:

Hello,

VISTA computer: can you please tell me how to protect an xls woorkbook/file
so that people can use filters but Cannot change formats, delete cells,.....


Thank you !

Arno