Command buttons

[k209310]

Does anybody know the vb code to prevent a command button from printing?

I know you can prevent this in the preferences of the button but i was wondering what the actual code was.

 

[Iridium]

On 2002-10-29 07:20, k209310 wrote:
Does anybody know the vb code to prevent a command button from printing?

I know you can prevent this in the preferences of the button but i was wondering what the actual code was.

Try something on the lines of


ActiveSheet.Shapes("Button 19").Select
With Selection
.PrintObject = False
End With
End Sub

 

[k209310]

ActiveSheet.Shapes("Button 19").Select
With Selection
.PrintObject = False
End With
End Sub


when its run i get a data object not found error on this line.

.PrintObject =