Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Cannot find macro coding location in Excel

  • 19-08-2025 11:25AM
    #1
    HPMan
    Registered Users, Registered Users 2 Posts: 151 ✭✭


    Hi all,

    i have a spreadsheet program which is from 1993 used regularly containing about 30 separate spreadsheets within the program folder. Each of the 30 spreadsheets have macros for printing, insert new row, saving the file etc- we would like to see the coding / macros so we can copy them to new spreadsheets we create but we cannot find the location of where the Excel4 macros are.

    Can anyone suggest where these might be located.

    regards



Comments

  • #2
    Kimbot
    Moderators, Computer Games Moderators, Social & Fun Moderators Posts: 18,973 Mod ✭✭✭✭Kimbot


    Excel 4.0 (XLM) macros are typically found within macro sheets, which are separate sheets in an Excel workbook, not within VBA modules. These macro sheets can be identified by their .xlm extension. To locate them, you can use the Document Inspector or the View Macros option in Excel. Additionally, Excel 4.0 macros can be restricted by default for security reasons, and you might need to adjust the Trust Center settings to enable them. 

    https://www.youtube.com/watch?v=IJQHMFLXk_c&t=808



  • #3
    10-10-20
    Registered Users, Registered Users 2, Paid Member Posts: 9,383 ✭✭✭10-10-20


    There's a python module for that, if that's your cup-of-tea. Not sure it will work on Excel4 though.

    https://medium.com/r3d-buck3t/extracting-macros-with-oletools-6c3a64c02549



Advertisement