Auto Filter

**craig.jenkins** · 11-30-2007, 11:18 AM

Hi All,

Is there a way to use the auto filter when all cells on a spreadsheet are protected. It doesnt appear to work when cells are protected.

Cheers

Craig.

**VBA Noob** · 11-30-2007, 11:23 AM

Maybe link will help

http://www.bettersolutions.com/excel...E028820332.htm

When protecting sheet tick autofilter

VBA Noob

**Ron Coderre** · 11-30-2007, 11:30 AM

You need to set up the AutoFilter BEFORE you protect the sheet. The protection will allow you to USE the AF...but not create one.

Remember to Check: Use AutoFilter...when engaging protection.

Does that help?

**craig.jenkins** · 11-30-2007, 11:31 AM

Thanks mate but I only have to option to protect

Contents
Objects
Scenarios

Any ideas?

Cheers

Craig.

**craig.jenkins** · 12-03-2007, 06:35 AM

Thanks mate but I only have to option to protect

Contents
Objects
Scenarios

Any ideas?

Cheers

Craig.

**craig.jenkins** · 12-03-2007, 07:09 AM

Sorted it,

Use the following link

http://office.microsoft.com/en-us/ex...982701033.aspx

**craig.jenkins** · 12-20-2007, 08:51 AM

Hi All,

I using this VBA code to protect a sheet to enable me to use the autofilter. This works great but I want to be able to do this in a shared workbook but for some reason this does not work. Any ideas?

Cheers

Craig.

Please Login or Register  to view this content.

**craig.jenkins** · 12-24-2007, 10:31 AM

Bump..........

**craig.jenkins** · 01-03-2008, 06:30 AM

Hi Guys,

I'm not sure if my previous query can be done so I was wondering if there was a way to automatically save and close a work book after a specified time.

Thanks
Craig.