VB Form: whole form won't print

[auroastra]

Hello,

I have made a VB form for a worksheet with a "Print" command button (housed on the worksheet--not the form but coded to refer to the form). Form Height =1850 with 20 items but when the "Print" command button is pressed, it only prints 6 (of 20) items...just a page worth.

Sorry, am new to using VB in excel and just learning.

Chris

 

[auroastra]

Hello everyone,
I found the key to this and wanted everyone to know. It is a Microsoft bug that causes this (see this website: http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q191130&)

On our network we only have excel 97 and I'm sure our IT group has not downloaded the fix. SO YOU CAN'T PRINT THE WHOLE FORM!!!

Does anyone know any 'goto' code I can use to print sections of the form perhaps?

Help,
Astra

On 2002-04-25 06:47, auroastra wrote:
Hello,

I have made a VB form for a worksheet with a "Print" command button (housed on the worksheet--not the form but coded to refer to the form). Form Height =1850 with 20 items but when the "Print" command button is pressed, it only prints 6 (of 20) items...just a page worth.

Sorry, am new to using VB in excel and just learning.

Chris

 

[Joe Was]

This may work in 97? I use 2000 & XP.
On the sheet that you want to print format the print with SetPageLength and PageSetUp from the menu. Excel will remember each sheets print setup. Then build a macro with this code.

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

You may need to add a Sheets("xxxx").Select code above the PrintOut code?

Where "xxxx" is your sheet name?

Build a Form Button on the sheet and attach the macro.

This should print out the whole sheet, based upon how you setup the print for that sheet?

If the forms do not print, only the sheet that they are on, you may need to set the form property to print with sheet.

Hope this helps. JSW