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 |
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 |
All times are GMT +1. The time now is 12:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com