How to hide and unhide the button with vba code

[ShaunJ]

Hi guys,
I have some questions about hiding and unhiding buttons. Here comes my code, and I rename the button "Cal" and the error is that "Object doesn't support this property or method"

here is my code


Sub ClearForm()

Dim ReportSheet As Worksheet
Set ReportSheet = Worksheets(2)

Worksheets("Report").ClearContents

ReportSheet.Shapes("Rec").Visible = False

[A1].Select

End Sub

 

[Domenic]

Which line is giving you the error? It looks like it's probably this one . . . .

Worksheets("Report").ClearContents

ClearContents is a method of the Range object, not the Worksheet object. Try the following instead . . .

Worksheets("Report").Cells.ClearContents

 

[ShaunJ]

Which line is giving you the error? It looks like it's probably this one . . . .

Worksheets("Report").ClearContents

ClearContents is a method of the Range object, not the Worksheet object. Try the following instead . . .

Worksheets("Report").Cells.ClearContents

Appreciate it. That works

 

[Domenic]

You're very welcome, cheers!