Hide Columns in Bex Excel Workbook

[xmchx]

Dear all,

I have an Excel Workbook which looks like this:

Column 1=Characteristic Column 2-7=key figure month 1 Column 8-13 key figure month 2 .... column 14-19 total key figures all months

In the start view we would like to hide the columns 14 to 19 with the excel standard functionality "hide column".

We tried to save the wookbook with hidden columns 14-19, but if we open the workbook again, we still see the columns 14-19.

We do not want, that the end user has to activate the total setting for each key figure column.

Is there a possiblity to save the workbook with hidden (excel functionality hide column) columns? Is this possible without VBA-coding? If we need VBA-coding, maybe you can post a coding proposal.

Thanks a lot!

xmchx

[djbenice]

Hi There,

Hiding them should work but if it's not working for you then try recording as a macro when you hide then; open the Visual Basic Editor by pushing ALT + F11. Then click on the folder on the left side called MICROSOFT EXCEL OBJECTS. Now click the ThisWorkbook module. Enter this code on the right:

Private Sub Workbook_Open()
'Enter your macro here
End Sub