Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect xls workbook (Vista)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect xls workbook (Vista)
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect xls workbook (Vista)
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect xls workbook (Vista)
You're talking about 2 different things!, worksheet protection is done on a
sheet by sheet basis (or you can use a macro to do all of them) so you can set each sheets permissions differently, and workbook protection is for the whole structure. Protect Sheet and Protect Workbook are on the review tab. Regards, The Code Cage Team www.thecodecage.com/forumz "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect xls workbook (Vista)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
Vista Excel workbook ribbons | Setting up and Configuration of Excel | |||
Workbook.Open() Fails in Vista | Excel Programming | |||
Disable Tools, Protect, Protect Workbook | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming |