Skip to Content
0
Former Member
Apr 12, 2013 at 06:33 PM

SAP BPS - Enable Excel Filters in a protected Planning Layout (worksheet)

42 Views

Hello Guys,

I know BPS plannig layouts are protected with Macros which disable sort and filter functions. I've been looking for a way to enable the "Filter" option, but the only way I worked this out was by using the "SAP" password to unlock the worksheet. I want the plannig layout still being protected but with the filter option enabled.

I'm not a master using VBA macros. Please help me!!!