Consulting

Results 1 to 3 of 3

Thread: Macros not showing?

  1. #1
    VBAX Regular
    Joined
    Sep 2018
    Location
    Singapore
    Posts
    6
    Location

    Macros not showing?

    I get a macro warning in my workbook but when I go to Tools> Macro> Macros (Excel prior to 2007) or Developer/Macros (Excel 2007 and on), I see no macros listed. Is there another place to look?

  2. #2
    VBAX Expert Logit's Avatar
    Joined
    Sep 2016
    Posts
    528
    Location
    .
    The macros in your workbook must be designated as PRIVATE.

    Go into the VBE and click on one of the MODULES or SHEETS on the left side.

    To get to the VBE, click on DEVELOPER / VISUAL BASIC.

  3. #3
    Knowledge Base Approver VBAX Wizard
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,336
    …they could also carry arguments, or be user defined functions with arguments.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Tags for this Thread

Posting Permissions

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