CODEWITHSUNDEEP
vbaprintinguserform
Noldor130884
Noldor130884

Reputation: 994

hide userform to printer in VBA

I have this problem with a device I'm trying to program:

I needed to add a "Print" button to a userform, which would have to print the screen image. I managed to build the userform, to add the button and finally to find the built-in VBA command that will print what the device screen shows.

Of course I have no use for my userform to show up in my prints, but no matter what I can't hide it to my printer.

I tried:

Userform.hide
Userform.zoom = 10
Userform.visible = false

But none of these seem to work.

Upvotes: 0

Views: 395

Answers (1)

Noldor130884
Noldor130884

Reputation: 994

I had to move the userform outside the screen using the "Move" command:

Userform.move right,down

Upvotes: 0

Related Questions