Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter problem in Mac, but works in Windows, Excel 2003
I work in Excel 2003 (Windows) and have set up an autofilter and password
protection. Autofilter works a treat, no problems. But when this same file is opened on a Mac, the autofilter is inoperable. Any ideas? It does work if the password protection is removed, but I want to leave it on. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofilter problem in Mac, but works in Windows, Excel 2003
xl2003 has an option to allow autofilter when you protect the worksheet. I'm
not sure if the version you're using on the Mac supports it. xl2002 was the first version of windows excel to have this. In earlier versions, you could use a macro. If you already have the outline/subtotals/autofilter 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 If .FilterMode Then .ShowAllData End If End With End Sub It needs to be reset each time you open the workbook. (Earlier versions of excel don't remember it after closing the workbook. IIRC, xl2002+ will remember the allow autofilter setting under tools|Protection|protect sheet, but that won't help when you're filtering via code.) ==== If this doesn't help, you may want to post your question he news://msnews.microsoft.com/microsof...c.office.excel if you don't get a good response. Curran wrote: I work in Excel 2003 (Windows) and have set up an autofilter and password protection. Autofilter works a treat, no problems. But when this same file is opened on a Mac, the autofilter is inoperable. Any ideas? It does work if the password protection is removed, but I want to leave it on. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2003 AUTOFILTER PROBLEM | Excel Discussion (Misc queries) | |||
How can I convert an excell file from windows 98 on to works spr. | Excel Discussion (Misc queries) | |||
Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Slowness problem in Windows XP | Excel Discussion (Misc queries) | |||
Windows search in Excel with autofilter | Excel Discussion (Misc queries) |