Enable Autofilter Functionality For A Protected Worksheet

Topics:
Software tips
Tags:
Microsoft Corp.,
Microsoft Excel,
Microsoft Office,
Microsoft VBA,
Office Suites,
Software
Source:
Microsoft

FREE Registration is required

Overview: By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that functionality manually. If you use Excel 2000, you need to use a few lines of Microsoft Visual Basic for Applications (VBA) code. You use AutoFilter to quickly find and work with subsets of the information in a worksheet. The following paper provides more information about using the AutoFilter command.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format: HTML | Pages: 11

People who downloaded this item also downloaded

Tools & Templates Sample Payroll Register
White Paper Exchange (Copy, Import, Export) Data Between Excel And Access
White Paper You Asked For It: Crabby's Top 5 Excel Tips And Tricks
White Paper Create A Euro Conversion Table In Excel
White Paper From Access To Excel: Quick Financial Charts

Top results from Software tips

White Paper Leveraging Accounts Payable Automation as a Service
Download IT Help Desk Survival Guide, Third Edition
Download Crash Course: Microsoft Outlook
Download Crash Course: Microsoft Word
Download Crash Course: HTML

» View all Software tips listings

advertisement
advertisement
  • Click Here
  • Click Here
  • Click Here
advertisement

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this directory, you become a member of BNET. In addition, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a directory registrant, you will receive a complimentary subscription to the BNET member newsletter, The BNET Report. You can unsubscribe from this newsletter at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).