Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Filter in protected sheet
Sir,
I want to use data filter command in protected sheet. Oncly Because that formula i m using in the cells should not display or suddenly can delete or currupt. Is there any way? Regards Rao Ratan Singh |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Filter in protected sheet
If you already have the outline/subtotals applied, you can protect the worksheet
in code (auto_open/workbook_open??). Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True '.EnableOutlining = True .EnableAutoFilter = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember it after closing the workbook.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Rao Ratan Singh wrote: Sir, I want to use data filter command in protected sheet. Oncly Because that formula i m using in the cells should not display or suddenly can delete or currupt. Is there any way? Regards Rao Ratan Singh -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |