If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column widths - strange problem
I create a spreadsheet through VB code. If I create it on my machine
everything works just fine. However, if the end user creates it on his machine it does not print correctly. It is the column widths that are the problem. Although the column widths say they are the same on each spreadsheet a simple visual inspection indicates they are not. The only difference I can see is the Row Numbers and Column Letters. It appears to me that on his Excel they are Roman where as on mine they are Arial. It is my understanding that the column widths are based on the number of characters that can fit in the column. How can I change the Column Letters and Row Numbers to arial. Or could it be some other problem? -- M. Shipp |
#2
|
|||
|
|||
Column widths - strange problem
Check the font for the NORMAL style
"SHIPP" wrote: I create a spreadsheet through VB code. If I create it on my machine everything works just fine. However, if the end user creates it on his machine it does not print correctly. It is the column widths that are the problem. Although the column widths say they are the same on each spreadsheet a simple visual inspection indicates they are not. The only difference I can see is the Row Numbers and Column Letters. It appears to me that on his Excel they are Roman where as on mine they are Arial. It is my understanding that the column widths are based on the number of characters that can fit in the column. How can I change the Column Letters and Row Numbers to arial. Or could it be some other problem? -- M. Shipp |
#3
|
|||
|
|||
Column widths - strange problem
The font and other formats of the column & row designators are controlled by
Style: Format Style Normal modify -- Gary''s Student - gsnu200819 "SHIPP" wrote: I create a spreadsheet through VB code. If I create it on my machine everything works just fine. However, if the end user creates it on his machine it does not print correctly. It is the column widths that are the problem. Although the column widths say they are the same on each spreadsheet a simple visual inspection indicates they are not. The only difference I can see is the Row Numbers and Column Letters. It appears to me that on his Excel they are Roman where as on mine they are Arial. It is my understanding that the column widths are based on the number of characters that can fit in the column. How can I change the Column Letters and Row Numbers to arial. Or could it be some other problem? -- M. Shipp |
Thread Tools | |
Display Modes | |
|
|