Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home

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.


Check out our Excel VBA Resources

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

Posted by JOJO on February 04, 2002 3:27 AM
boymoi@yahoo.com


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.