on 03-23-2006 7:18 AM
Hello Gurus,
I have created BEX report in which user want 1st two column (Material and its describtion) to be fixed as if he want to check all relavent result related to Material the first 2 column should not be move it should be fixed and rest other results and other column should move,
Hi,
If u want 2 fix first two columns, then select 3 rd column. And then in menu "<b>Window</b>" select <b>freeze panes</b>.
suppose want to fix first row select second row and do freeze panes.
If u want to fix both rows and columns select the intersection of next row and next column.
Hope its clear.
reward if useful.
shylaja.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for ur answers,
well it dosent help much,
my question is that i just want to fix first 2 columns and rest should move.The query which i design is v long in width so what i want that 1st two column(material and its describtion) should as it is while rest of columns move (scrole) so all related results and other feilds displayes in front of 1st two column i.e,Material and its describtion.
Hi Wajid,
The VBA code i gave earlier will do this automatically for your users. Please use it. It freezest columns A and B so that columns A and B dont move even if your users scroll to the right. It just stays there.
In your workbook after you have inserted your query, go to Tools->Macro->Visual Basic Editor. Then go to Insert Menu->Module. Double click the module that have been created (probable name is Module1) and then on the code editor paste this code:
Public Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Range("C1").Select
ActiveWindow.FreezePanes = True
End Sub
Everytime the users refresh your query it will freeze the first to columns. So at least you are sure that the columns A and B are frozen.
Hi,
You can do this via the following VBA code:
Public Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Range("C1").Select
ActiveWindow.FreezePanes = True
End Sub
Put this this code in a VBA module in your workbook. It will execute everytime the user refreshes the query and will freeze the first two columns (to the left of C1).
Message was edited by: Emmanuel Nepomuceno
Message was edited by: Emmanuel Nepomuceno
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi wajid,
select the colum -> right click-> select properties->column width
select the radio button " do not adjust the column width"
cheers
ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.