Excel2000/2007 Protection & Auto Filter

M

MSpaven75

I have an excel spreadsheet created in Excel 2000 that is protected, but it
contains some VB that allows the Auto Filter and Hyperlink functionality to
remain active, once the file has been opened in Excel 2007 and saved (in
97/2000 compatability mode) the Auto Filter no longer works, but the
hyperlinks do. Any ideas?
 

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

Auto-filter selection 1
Opening excel 2010 spreadsheet from Access 4
How do I protect a range but allow auto filtering in earlier versi 1
Excel opening MSSynch in 2010? How to stop it? 0
Excel 2007 Auto Filter Filter 2
Excel 2007 compatibility issue - speed between cells 2
Macro to allow auto filter after running password protect 1
Auto Filter in EXCEL 2007 4

Top