Spreadsheet control in a custom form

  • Thread starter Thread starter Denise
  • Start date Start date
D

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
 
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
 
Outlook version? Could you show the code that you're using to populate the
spreadsheet? What size do you want it to be?
 
Back
Top