cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi,

BPS expects the cells in a certain position, so you have to be careful with Excel functionality like filtering and sorting, cf.

http://help.sap.com/saphelp_sem60ep1/helpdata/en/05/242537cedf2056e10000009b38f936/frameset.htm

If you want the full flexibility for the end user you have to copy the data from the SAP controlled worksheet to another worksheet, make the changes there and copy the data back to the SAP worksheet. In the process you have to ensure that the positions in the SAP worksheet are stable.

In other words, this requires some VBA programming; the data copy can be implemented in the 'exits', Modul1.SAPAfterDataPut and Modul1.SAPAfterDataPut.

Regards,

Gregor

amine_lamkaissi
Active Contributor
0 Kudos

Hi,

Try this command in your Excel macro editor:

Worksheets("name of your sheet").AutoFilterMode = true

Hope it helps.

Amine