PDA

View Full Version : Spreadsheet Control changing its size at runtime



gonen
05-07-2011, 11:49 AM
Hello

I am using Spreadsheet Control in few of my userforms.

I have noticed, that while I design it to be with specific size - it does not keep it's size at runtime.

Is id displayed in the form smaller than the size I designed it on the form, and saved it.


All other properties are ok, and the application works with the spreadsheet control perfect.


Any idea why the displayed size is smaller than the size I designed and saved ?

I am running on XP with office 2003 and XP with office 2007. Same problem in both.


thanks !!!

Rob342
05-13-2011, 02:03 PM
You can set the forms width & height in properties on the form or when it is initilized.

Dont quite know what you mean by Spreadsheet Control ?

If you want to post a copy i'll take a look

Rob

mikerickson
05-13-2011, 03:55 PM
Are the control's propeties set to "Do not move or resize with cells"?