+ Reply to Thread
Results 1 to 3 of 3

XLSM Macros disabled - no option to enable

  1. #1
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    XLSM Macros disabled - no option to enable

    Hi,
    I am stumped on this one.
    I have an xlsm file that usually when opened, option to enable macros is displayed.
    However this seems to have stopped. When opened there is no option to enable macros?

    xls docs still open with macro option available.

    any ideas please?
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: XLSM Macros disabled - no option to enable

    do the macros work? perhaps it has been added to a trusted folder?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: XLSM Macros disabled - no option to enable

    I closed the file, re-opened it. Still no macro.
    doen this 3 times. tried opening from desktop shortcut, via excel, recent documents and original location. nothing!
    left it a while, tried it again and its now working.
    Very strange, its done this 3 times now in the last week on this file only.
    Cant figure it out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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