Manipulating data in Spreadsheet control

Hi,

I've created a OWC spreadsheet control (in a user form) and have managed to copy data from an existing worksheet onto it using:

Dim Rstr

Rstr = Sheets("Induction").UsedRange.Address

Me.Spreadsheet1.Sheets(1).Range(Rstr).Value = Sheets("Induction").UsedRange.Value

But so far, I am not able to apply auto filter nor hide certain columns in the spreadsheet control.

Can anyone help?