Skip to Content
avatar image
Former Member

Worksheet generation removes sheet protection

Hi All,

BPC 10.1, BW 7.5 SP2, AFO V2.3

I have a template which is password protected. I have named ranges with 3 ___ which are used in formatting sheet. I also have some macros - after_refresh to allow ungrouping of columns and keep sheet protected, etc.

When I am generating multiple sheets for a dimension using worksheet generation option, there are a few issues -

1. It removes the password protection from the sheets, however edit report button is greyed out.

2. Formatting goes for a toss as all cells are yellow while I had few as grey and few as yellow based on name ranges - not sure if it is because of named ranges.

I have the inherit sheet options activated in template and Apply dynamic formatting sheet is activated in sheet options, so same formatting sheet should apply all across.

Is this known behavior (specially on the password protection)? Any solutions if someone has come across this earlier?

Regards,

Ashish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 20, 2017 at 07:51 AM

    Try AO 2.4!

    You can also write yourself worksheet generation procedure in VBA - just a simple copy sheet with page axis change...

    Add comment
    10|10000 characters needed characters exceeded