Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 07 - doc insp says there's a hidden worksheet and there isn'
Hi,
I am having trouble accessing a particular XLSM spreadsheet via OleDB from vb.Net and FW 2.5. As the spreadsheet was given to me, I was unable to access the desired sheets. I was sanitizing the spreadsheet to send to someone and I went to run document inspector to see if I needed to clean any other information out. First, the inspector told me that it could not run because I had protected worksheets. So I unprotected the protected worksheets and re-ran the inspector. It told me that that I had 1 hidden worksheet. So I let it remove that. Anyway, once I had performed the above steps, I was able to access the desired worksheets. I also tried saving the original XLSM as an XLSX and got the same results as witht eh original XLSM file. I was able to access the data by saving the XLSM as an XLS file. As a test, I restored my copy and just removed the protection from the protected worksheets and did not unhide the other worksheet and was still unable to access the data without getting the error that I got before. I can only access the data after clicking on Remove All for the Hidden Worksheets. The problem now is that I was unable to find a worksheet to unhide from the Format/Hide and Unhide/Unhide sheet as this option was disabled. So I looked for any VeryHidden sheets via VBA (going through the worksheets collection) and visually in the project exlporer tree, but found nothing. Here's the code I used to look into the collection: Sub ShowSheets() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets MsgBox wks.Name & " - " & wks.Visible Next wks End Sub How can the document inspector see a hidden sheet and I cannot? Can you tell me whether or not the Remove All command for the hidden worksheet in the document inspector actually deletes or unhides a worksheet? Also, can you tell me exactly what should be able to stop me from being able to access the data? Items such as hidden worksheets/cells, protected worksheets/cells, etc. Thanks, Bobby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FYI Excel 2007: Saving a xlsm file with a hidden worksheet activated makes worksheet visible | Excel Programming | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |