Accessing a proteced workbook/sheet from VBA

Hi,

My company has an application that creates an Excel worksheet. The problem is that I need to copy-n-paste a number of columns - but the whole thing is protected, it has no tool bars or any other way of getting at the data - including select and Ctrl-C!

If I fire up another workbook and access the VBE only the workbook for the latter shows up - the application generated workbook does not appear - also MsgBox Workbooks.Count shows 1.

Can anybody help? I would like to access the locked worksheet via VBA.

Thanks in advance.