Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Data Filter in protected sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rao Ratan Singh - 19 Jan 2006 13:18 GMT
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 - 19 Jan 2006 15:37 GMT
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

> Sir,
> I want to use data filter command in protected sheet. Oncly Because that
[quoted text clipped - 6 lines]
>
> Rao Ratan Singh

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.