Accessing a proteced workbook/sheet from VBA
Posted by Hardev Sanghera on February 04, 2002 2:49 AM
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.