Help me to make this macro Working, please...

[marco]

Hi all,

I've used the following macro to be able to use autofilter in an excel
sheet... under excel for windows it works but under excel for mac it
returns an error at this row:

..Protect UserInterfaceOnly:=True


Sub abilitafiltrosufoglioprotetto()
With ActiveSheet
.Protect UserInterfaceOnly:=True
.EnableAutoFilter = True
.EnableOutlining = True
End With
End Sub



Could you help me, please?

Thank you
Marco

 

[Bob Greenblatt]

Hi all,

I've used the following macro to be able to use autofilter in an excel
sheet... under excel for windows it works but under excel for mac it
returns an error at this row:

.Protect UserInterfaceOnly:=True



Sub abilitafiltrosufoglioprotetto()
With ActiveSheet
.Protect UserInterfaceOnly:=True
.EnableAutoFilter = True
.EnableOutlining = True
End With
End Sub



Could you help me, please?

Thank you
Marco

Marco,

Are you sure that the active sheet is the sheet that you want to protect? Is
it already protected?

 

[marco]

Marco,

Are you sure that the active sheet is the sheet that you want to protect? Is
it already protected?

Thank you BOB,

yes, my sheet is protected, so I would like to unprotect only the filter
interface.
In fact, using Win Excel it works... so why doesn't it works under Mac
Excel?

Thank you
Marco

 

[JE McGimpsey]

yes, my sheet is protected, so I would like to unprotect only the
filter interface. In fact, using Win Excel it works... so why doesn't
it works under Mac Excel?

Hmmm... it works for me using XLv.X or XL2004. Was the file protected
under XL02/3, and if so, was cell protection involved?

I'd be glad to take a look at the file if you'd like to send it to me.