+ Reply to Thread
Results 1 to 8 of 8

Error message about macros - but I have no macros in my file?!

  1. #1
    Registered User
    Join Date
    06-21-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    5

    Unhappy Error message about macros - but I have no macros in my file?!

    Hi all,

    I have built a normal workbook and saved it in binary format.
    I am trying to apply a password to the file but keep getting this error message

    "The workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to password protect or restrict permission to this document, you need to remove these macros"

    I have not built in any macros into this file, but I suspect some coding has automatically been added somewhere along the way
    I have inspected VBA editor but cannot see any modules or coding.

    The only way around this is to save the file as 97-2003 format, but this is making the file size humongous, and not ideal.

    Please can someone help me with this!

    Thanks

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Error message about macros - but I have no macros in my file?!

    Hi,

    Are there any macro sheets in the workbook or have you used any XLM functions in defined names, such as EVALUATE, or GET.WORKBOOK?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    06-21-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Error message about macros - but I have no macros in my file?!

    I just checked Name Manager and there is a whole list of Macro names? How did that happen?
    Last edited by Hshah; 07-15-2016 at 05:50 AM.

  4. #4
    Registered User
    Join Date
    06-21-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Error message about macros - but I have no macros in my file?!

    I have deleted all the Macros now, but the error message is still coming up...

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Error message about macros - but I have no macros in my file?!

    Can you attach the workbook here, please? You can remove all data from the workbook first but please do not change the structure in any way.

  6. #6
    Registered User
    Join Date
    06-21-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Error message about macros - but I have no macros in my file?!

    Ok, file attached.

    I have removed all the data and any pivot tables but other than that the tabs are in the same place. I tested for the password protection again, and the error is still coming up.

    If you manage to resolve the issue, please can you share your steps with me so I can replicate.

    Thanks for your help!
    Attached Files Attached Files

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Error message about macros - but I have no macros in my file?!

    You have a hidden Excel 4 macro sheet in the workbook. To see it, use this code:

    Please Login or Register  to view this content.
    You may then review and delete the sheets as applicable.

  8. #8
    Registered User
    Join Date
    06-21-2016
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Error message about macros - but I have no macros in my file?!

    It worked! Thanks so much for your help I'll monitor it, but hopefully shouldn't have any more issues

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  2. Excel Document with Macros or Access file with Macros
    By jcchs2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2015, 01:21 PM
  3. How do I Disable Macros on a File where Macros were Previously Enabled?
    By Alves76 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2013, 10:26 AM
  4. Creating error message in Excel using Macros
    By ecrolley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 02:29 AM
  5. Replies: 5
    Last Post: 07-26-2012, 09:38 PM
  6. Combining two macros results in error message
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2009, 02:42 PM
  7. 'Enable Macros' message with no macros
    By nebb in forum Excel General
    Replies: 1
    Last Post: 06-07-2007, 07:04 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1