ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Autofilter unavailable (https://www.excelbanter.com/excel-worksheet-functions/249958-autofilter-unavailable.html)

Julieeeee

Autofilter unavailable
 
The Autofilter option is not available in the sheet I am working in. It is
grayed out. The file is not protected. Any ideas? (I'm using 2003)

Gord Dibben

Autofilter unavailable
 
You say the file is not protected but could be the worksheet is protected.

Is ToolsProtectionUnprotect Sheet available?

If not sheet protection...................

Anything else grayed out?

If you have more than one sheet selected lots of functions will be grayed
out...........AF among them.


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 14:53:01 -0800, Julieeeee
wrote:

The Autofilter option is not available in the sheet I am working in. It is
grayed out. The file is not protected. Any ideas? (I'm using 2003)




All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com