This website is not affiliated with, sponsored by, or approved by SAP AG.

Hide Columns in Bex Excel Workbook

Business Warehouse

Moderators: Snowy, thx4allthefish

Hide Columns in Bex Excel Workbook

Postby xmchx » Wed Jul 18, 2012 1:43 am

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
xmchx
 
Posts: 73
Joined: Sun Apr 05, 2009 11:10 pm

Re: Hide Columns in Bex Excel Workbook

Postby djbenice » Fri Jul 20, 2012 7:24 am

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
djbenice
 
Posts: 50
Joined: Mon Jan 16, 2006 6:51 am


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 2 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.