Spreadsheet control in a custom form

[Denise]

Hi, I created a custom form controlled by some VB script.
The form has a to, cc, subject, control button to print
screen, a body, and a spreadsheet control.

I'm trying to troubleshoot attaining the particular size I
would like to assign to the spreadsheet and it will retain
my settings. I am using the advanced properties and the
property tool box on the spreadsheet. I've tried
everything the help screen has provided and everytime I
run the form or switch between the compose and read page
the sheet expands to full size 1:65536 cells.

Can anyone please help me?? I have spent hours trying to
fix it.

My work email is (e-mail address removed)
My home email is (e-mail address removed)

Thank you very much for your help in advance.

Denise

 

[Jay]

Have you tried setting the spreadsheet properties (i.e. width, height) in the code behind at run-time? You can then also set the range of cells you want to display

----- Denise wrote: ----

Hi, I created a custom form controlled by some VB script
The form has a to, cc, subject, control button to print
screen, a body, and a spreadsheet control

I'm trying to troubleshoot attaining the particular size I
would like to assign to the spreadsheet and it will retain
my settings. I am using the advanced properties and the
property tool box on the spreadsheet. I've tried
everything the help screen has provided and everytime I
run the form or switch between the compose and read page
the sheet expands to full size 1:65536 cells

Can anyone please help me?? I have spent hours trying to
fix it

My work email is (e-mail address removed)
My home email is (e-mail address removed)

Thank you very much for your help in advance

Denis

 

[Sue Mosher [MVP-Outlook]]

Outlook version? Could you show the code that you're using to populate the
spreadsheet? What size do you want it to be?