MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Accessing a proteced workbook/sheet from VBA


Posted by Hardev Sanghera on February 04, 2002 2:49 AM

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.


Posted by JOJO on February 04, 2002 3:27 AM

SENT YOUR FILE TO ME AND I CRACK IT..CHEERS..MY EMAIL IINSIDE

boymoi@yahoo.com