Windows 10: Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Discus and support Excel 2010 Document Inspector reports hidden sheets, not shown in VBA in Microsoft Office and 365 to solve the problem; I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time... Discussion in 'Microsoft Office and 365' started by tpriest, Jul 30, 2019.

  1. tpriest Win User

    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA


    I have a worksheet with 14 tabs along the bottom. I've had the worksheet for many years - creation date is 16 November 1997 -and it's evolved over time to be more and more useful. Obviously been through many versions of Excel. It has several user functions and VBA procedures.

    I'm currently running Excel 2010 and, out of curiosity, decided to run Document Inspector and see what it reported.

    All the messages, except one, was what I expected. The exception was that it reported 2 hidden sheets.

    I can't what it's referring to. The VBA list of Objects lists the expected 14 worksheets.

    I could, having made a copy, let Inspector remove the hidden sheets it's found, but I rather know what they are beforehand.

    Any thoughts on how to progress this? Of course it may be a bug in Excel, it may be something left over from previous versions of Excel.

    :)
     
    tpriest, Jul 30, 2019
    #1
  2. Brink Win User

    New Document Inspector for Excel, PowerPoint, and Word


    Source...
     
    Brink, Jul 30, 2019
    #2
  3. Josje Win User
    Storing Pictures in Excel Sheet

    Hi Now,



    I posted the following on the MSDN Excel forum, and the answer was that the suggested method (in particular the VBA) is not available.

    But perhaps there is another way to accomplish the task?

    I would be ever so thankfull for a good suggestion



    Jos



    PS: A have experience with VBA, VBScript



    ---- previously posted:



    Hi,

    My boss wants me to buy a PDA with Windows Mobile 6. The customer sends a

    "normal" Excel-sheet of objects to be inspected. After loading into to PDA

    the workers have to take a picture of objects that fail inspection. The

    picture then has to be linked to the Mobile-sheet by means of a hyperlink.

    I think this is possible used a bit of VBA in Excel, but does Excel Mobile

    support VBA?

    --

    Jos



    Answer something like,



    I think a no to that.
     
    Josje, Jul 30, 2019
    #3
  4. jimbo45 Win User

    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

    Office 2010 Excel: two sheets


    Hi there
    Just have the 2 different worksheets in one workbook - then just move the sheet you are interested in to the other monitor.

    Seemples !!!!


    Excel 2010 Document Inspector reports hidden sheets, not shown in VBA [​IMG]


    Cheers
    jimbo
     
    jimbo45, Jul 30, 2019
    #4
Thema:

Excel 2010 Document Inspector reports hidden sheets, not shown in VBA

Loading...
  1. Excel 2010 Document Inspector reports hidden sheets, not shown in VBA - Similar Threads - Excel 2010 Document

  2. Unable to Refresh Excel Sheet

    in Windows 10 Network and Sharing
    Unable to Refresh Excel Sheet: I have a DAQ system that's sending data to the computer and creating a .csv file. I want to have the sheet refreshed every X seconds/minutes without having to close the file and open it every time. This file is read-only. And when I go to the Data tab and click the arrow on...
  3. Excel sheet is automatically open

    in Windows 10 Customization
    Excel sheet is automatically open: Why Excel sheet is automatically pop-up many sheets when I turn on my PC https://answers.microsoft.com/en-us/windows/forum/all/excel-sheet-is-automatically-open/998d27e4-30b4-46a4-a225-0c8361ec18c6
  4. Excel shortcut to open to specific sheet

    in Microsoft Office and 365
    Excel shortcut to open to specific sheet: I have a shortcut to open Excel to a file: "C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE" c:\all\Workbooks\General.xlsm". Is there a way to specify the sheet? I tried adding the sheet name to the end of the shortcut but I get an error comment. 135993
  5. HIdden Files not shown

    in Windows 10 Support
    HIdden Files not shown: I have around 15 hidden files in c:\ that don't show up in file explorer even with 'show hidden files' checked in view options. Is this something Microsoft is doing deliberately? How do I get them to show up? 135218
  6. Excel Starter 2010

    in Windows 10 Network and Sharing
    Excel Starter 2010: After each automatic download from microsoft my Aspire Lap top locks up with a blank black screen after I log in with my pass code. I generally have to shut down and restart my computer in safe mode. Apparently the Task Manager does not start in the initial startup. The last...
  7. Office 2010 Excel: two sheets

    in Microsoft Office and 365
    Office 2010 Excel: two sheets: I have Office 2010 and I know there is some trick to do this, but I cannot find it anywhere. I have two monitors and at work I have the same setup. Person who use to work there I heard said it was a hack that they added to my system so I don't know what that is. Here is what...
  8. Updated computer with Excel sheet opened and now the excel sheet is deleted.

    in Windows 10 Installation and Upgrade
    Updated computer with Excel sheet opened and now the excel sheet is deleted.: I updated my computer on Friday and I believe I left an excel sheet I was working on open when I set it to "update and shut down". Now, on Monday, I tried to open the document. it opened, I saved it, and then the whole document went white and the mouse showed it was loading....
  9. Restore Excel file sheet

    in Windows 10 Network and Sharing
    Restore Excel file sheet: Working in an Excel file I mistakenly deleted a "sheet" is it possible to restore it? I've looked in the Recycle Bin, I've tried "restore previous version." https://answers.microsoft.com/en-us/windows/forum/all/restore-excel-file-sheet/7f8a11d4-0a49-45df-8396-c0d21791c1bc"
  10. New Document Inspector for Excel, PowerPoint, and Word

    in Windows 10 News
    New Document Inspector for Excel, PowerPoint, and Word: Beginning with the November and December 2014 updates for Microsoft Office 2013 and 2010, several enhancements are being added to the Document Inspector, also known as the “Check for Issues” tool in Excel, PowerPoint and Word. The Document Inspector helps you to prepare your...