Consulting

Results 1 to 8 of 8

Thread: Opening XLSM file with Excel 2007 does not display content

  1. #1

    Opening XLSM file with Excel 2007 does not display content

    Hi everyone
    - I opened xlsm file with office 2007 but it didn't display the content. I have enabled all macro, VBA
    - My computer is using Windows 10
    - Please help me
    file1.jpg

  2. #2
    VBAX Tutor
    Joined
    Dec 2008
    Posts
    271
    Location
    It cannot be excluded that the file window is hidden. Go to View tab and find Unhide button. Press it.

    Artik

  3. #3
    Quote Originally Posted by Artik View Post
    It cannot be excluded that the file window is hidden. Go to View tab and find Unhide button. Press it.

    Artik
    Unhide button is locked, I don't know why I can't open xlsm file, while I enabale all the macro, vba tool
    Thanks you for the reply
    aaa.jpg

  4. #4
    VBAX Tutor
    Joined
    Dec 2008
    Posts
    271
    Location
    After "opening" the file, go to the VBA editor (LeftAlt+F11) and see if it appears in the list of open projects. If it is not there, it is likely that the file has not been opened. In this case, it could be blocked by Excel.
    Unfortunately, I don't remember now where, but somewhere in Excel is a place where you can see a list of blocked files.

    Also read this article: https://support.office.com/en-us/art...d-1e6563e7686d

    Artik

  5. #5
    I tried to do as you said, VBA Editor is notthing, and list of blocked files - File block setting - trust center is only available in higher excel version, Where can I find it in office 2007?
    bbbb.jpg

  6. #6
    VBAX Tutor
    Joined
    Dec 2008
    Posts
    271
    Location
    Unfortunately, MSO 2007 was a very short episode in my life. I no longer have access to it.


    But another thought occurred to me. Maybe the macro is written so that if a condition is not met, the file is not opened. Admittedly, it seems to me that you should see for a moment that the file has been opened. If you want to go this way, change the settings in Excel so that files are opened without running macros (or at least you must agree to run them; in this case, do not agree to run macros). Try to open the file again without running macros. If the workbook shows up, it may mean that you need to look for the solution in the code. If the workbook is still not visible, it will indicate that Excel has blocked it.


    I probably don't have more ideas.

    Artik

  7. #7
    Knowledge Base Approver VBAX Guru
    Joined
    Apr 2012
    Posts
    4,519
    @Artik

    In that case the file can be opened with macros disabled (shift-Open).

  8. #8
    VBAX Tutor
    Joined
    Dec 2008
    Posts
    271
    Location
    Yes, but remember that it works only from the Excel interface. It will not work if you double-click to open a file from the file manager.

    Artik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •