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!!!