I have a userform with a spreadsheet on. Also a print button and
commondialog. But I just cant write a code that prints the spreadsheet.

I got this from Rody Meulman:..Record a manual print and copy the code to
the butten_click event...........

This dosn't work, because the macro menu is not visible when the userform is
shown. If I try to start macrorecording before showing the userform, the
recorder records absolutely nothing.

Please help

Regards Kjeldc

If you mean you have the spreadsheet control from the office web components
on your userform, then I don't see any property/method that will allow you to
print the worksheet. Perhaps you would need to copy the cells from the
sheet and paste them into a regular excel sheet, then paste that.

this may be the way microsoft protects themselves, if you can't open files,
save files or print, then not much chance this will be used instead of buying
excel itself.

--
Regars,
Tom Ogilvy


"Kjeldc" wrote:

I have a userform with a spreadsheet on. Also a print button and
commondialog. But I just cant write a code that prints the spreadsheet.

I got this from Rody Meulman:..Record a manual print and copy the code to
the butten_click event...........

This dosn't work, because the macro menu is not visible when the userform is
shown. If I try to start macrorecording before showing the userform, the
recorder records absolutely nothing.

Please help

Regards Kjeldc