using autofilter in a shared protected workbook excel 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in excel 2000 i cant use auto filters... when i protect the worksheet... i
tried using the code MS supplied yet when the workbook is shared you cant set
the protection and turn on user interface protection only… so
enableautofilters = true is useless … Please help how can I turn auto filters
on when the shared workbook is protected ????
 
If you share the workbook and protect the worksheet, then you can't change the
protection of that worksheet.

You're gonna have to choose--share the workbook, protect the worksheet or allow
autofiltering.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Activate "Show all" in a Protected Shared Workbook 1
Using Autofilter on Protected sheets 3
Code for multiple worksheets 1
Filtering a protected WS in a shared workbook - Excel 2000 3
Autofilter does not work on protected w/s even when "checked to allow" ?? 6
CHANGING POSITION OF AUTOFILTER LIST 4
Enabling Autofilter and Sorting in a Protected Sheet 2
When sharing, can I force an Excel document to open in a certain view? 0

Back
Top