Results 1 to 13 of 13

Macros Not Working

Threaded View

mycon73 Macros Not Working 10-23-2010, 11:22 AM
Palmetto Re: Macros Not Working 10-23-2010, 02:18 PM
mycon73 Re: Macros Not Working 10-23-2010, 11:33 PM
johnjohns Re: Macros Not Working 10-24-2010, 05:14 AM
Palmetto Re: Macros Not Working 10-24-2010, 08:28 AM
mycon73 Re: Macros Not Working 10-24-2010, 10:47 AM
royUK Re: Macros Not Working 10-24-2010, 12:50 PM
mycon73 Re: Macros Not Working 10-24-2010, 02:58 PM
mycon73 Re: Macros Not Working 10-25-2010, 11:29 AM
royUK Re: Macros Not Working 10-25-2010, 02:08 PM
mycon73 Re: Macros Not Working 10-25-2010, 04:12 PM
mycon73 Re: Macros Not Working 10-26-2010, 07:21 PM
cazo97 Re: Macros Not Working 10-12-2018, 12:59 PM
  1. #6
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,059

    Re: Macros Not Working

    Hi Palmetto & JohnJohns,

    Here's what I've done:

    I changed my settings per your instructions

    In a new file, I created a couple simplistic macros & save the file with "Excel Enable-Macros Workbook"

    Closed & Excel & reopened

    Now, I do get the security option message & selected enable macros

    These instructions seem to work great for new files created.


    However, I have a bunch of files that were created some time a go & have, what I call, "pre-define" macros. Meaning, I created the macros to primarily sort a bunch of rows or columns.

    Even after I close Excel & reopen it, I do not get the Security Option message.

    I even re-created my sort functions by creating another macro, Save the file.

    I'm trying to avoid having to re-create all my macros in my existing files.

    I attached a file for example.

    In this file, I have to command buttons.

    Here, you should be able to see my macro settings & advise what the correct settings are.

    I also added my primary directory as my trusted locations.

    Once, I am able to "enable" macros (permanently), I expect my macro issue will be resolved with my existing files that have macros in them.

    Thanks again for the assistance.
    Attached Files Attached Files

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