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 Mentor Logit's Avatar
    Joined
    Sep 2016
    Posts
    356
    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 Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,307
    …they could also carry arguments, or be user defined functions with arguments.
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    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
  •