Results 1 to 3 of 3
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Hide Macros Excel 95

    Is it possible to Hide Macros (Not Module sheets, that's easy) from appearing on the Macro List in Excel 95 ?

    I am happy to control this from VBA if needed.
    andrew@d-l-r.co.uk
    Andrew

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide Macros Excel 95

    I don't know about 95, but in 97+, if you preced the module definition with "Private" they do not appear on popup lists.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Hide Macros Excel 95

    Top Man. Thanks.
    I should have known that, just wasn't thinking hard enough I guess.
    Now if you know an answer to my other posting that would be perfect.

    Andrew
    Andrew

Posting Permissions

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