Forum Discussion

webster13g's avatar
webster13g
Copper Contributor
Nov 22, 2023

Macros for excel

My computer will not let Macros run. I have enabled and everything and it is not working.

Macros and VBA

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Nov 22, 2023

    webster13g 

    Microsoft Excel and the operating system (OS) can play a role in how macros are handled and executed. Here are some considerations for each:

    Excel Version:

    1. Macro Security Features:

    Different versions of Excel may have variations in their macro security features. Newer versions often have more robust security settings to protect users from potentially harmful macros.

    2. Macro Language Support:

    Excel versions may have differences in the supported macro languages. For example, Excel for Mac may use AppleScript alongside VBA (Visual Basic for Applications).

    3. Macro-Enabled Workbook Format:

    Macro-enabled workbooks (.xlsm) are supported in newer versions of Excel. If you are using an older version, it might not fully support the .xlsm format.

    Operating System:

    1. Macro Execution Policies:

    The operating system can influence how macros are executed. For example, certain security policies or settings in the operating system may impact the ability to run macros.

    2. File System Permissions:

    The operating system manages file system permissions. Ensure that the user running Excel has the necessary permissions to access and execute macros from the location where the workbook is stored.

    3. Compatibility Issues:

    Compatibility issues between Excel versions and operating systems can affect macro execution. It's generally recommended to use a version of Excel that is compatible with your operating system.

    Recommendations:

    • Keep Software Updated: Ensure that both Microsoft Excel and your operating system are up to date with the latest patches and updates. This can resolve known issues and improve compatibility.
    • Check Compatibility: Before creating or running macros, check the compatibility of the macro features with your specific version of Excel and your operating system.
    • Security Settings: Understand and configure the security settings in both Excel and your operating system to allow for the execution of macros while maintaining a secure environment.
    • Check Microsoft Documentation: Refer to the official Microsoft documentation for your specific Excel version and operating system to understand any specific considerations or known issues related to macros.

    If you provide details about the specific Excel version and operating system you are using, it may be possible to give more targeted advice. AI was partially deployed to support the text.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

    Was the answer useful? Mark as best response and Like it!

    This will help all forum participants.

Resources