Results 1 to 9 of 9
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    I emailed an Excel spreadsheet to a client so they could fill in some information. When I got it back, the .xls file was now a .xlsm file - macro enabled apparently. When I use Excel 2007 and select View Macro, there is nothing shown there. Is it possible there is no macro and that somehow the extension got changed by accident? Or is it possible there is something hidden that I am not seeing?

    The spreadsheet went through a few different people after I sent it out to the client, so it is difficult for me to contact everyone who may have worked on it.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Did you remember to check the Sheets for macro as well? Also - make sure no Forms or Classes were added.

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    Quote Originally Posted by mbarron View Post
    Did you remember to check the Sheets for macro as well? Also - make sure no Forms or Classes were added.
    How do I do these things?

    Thanks

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Also, some Named formulas using XLM Functions will require that the file be saved as an xlsm.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try saving the file as a macro-free workbook (xlsx). If Excel does not complain about loosing a VBA project then there is no VBA code in the file.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    While in the VBE look for these:
    Right click and choose Remove if you see any of the ones by the RED arrows.
    For the Sheets and ThisWorkbook, double click on each one and clear out the code that opens.

    [attachment=87956:here.jpg]
    Attached Images Attached Images

  7. #7
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    Quote Originally Posted by mbarron View Post
    While in the VBE look for these:
    Right click and choose Remove if you see any of the ones by the RED arrows.
    For the Sheets and ThisWorkbook, double click on each one and clear out the code that opens.

    [attachment=87956:here.jpg]
    How do I get this file open in the VBE?
    Thanks

  8. #8
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Open the file as you normally would.
    Right click on a Tab and choose View Code.
    or
    press Alt+11

  9. #9
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    654
    Thanks
    95
    Thanked 14 Times in 13 Posts
    OK thanks.

    There is nothing on any of the sheets, and no forms, modules, etc.
    and when I save it as .xlsx there is no message.

    I guess it is clean.

    Thanks

Posting Permissions

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