Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Can I package XLM macros with Excel 2000?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    jackosullivan
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Having worked with Excel since Version 2 or so, I have a bunch of very handy old XLM macros that I have turned into Add-Ins. And since they are mostly just engineering equations, they work just fine under Excel 2000.

    But rather than force everyone who receives one of my workbooks to go through the stork dance of copying my .xlm file into their xlstart folder and doing all the Add-In stuff, I would like to force these routines into an Excel 2000 Template of some kind.

    Is there any way to include a hidden XLM sheet in an Excel 2000 Workbook or Template?

    Thanks very much.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is a belated answer, but yes. Excel4 macro sheets are still supported.

    The easiest way to make a template workbook using this is to open Excel, then open your file with the XLMs using File|Open.

    This should preserve your macro sheets and convert any module sheets into VBA modules.

    Additionally, you can still add Excel 4 macro sheets and Excel 5 Dialog sheets. The easiest way to do this is to right click on a worksheet tab and select "Insert", you should be able to select the Excel 4 or 5 objects there as well.

    ..and once you have this sheet in you can simply hide the sheet.
    _________________
    [b] Mark O'Brien

    [ This Message was edited by: Mark O'Brien on 2002-04-15 12:13 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    jackosullivan
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks very much, Mark.

    It was a lot simpler than I thought it would be, and seems to have worked just fine. (Not often I get to say that after wrestling with an MS product ;.)

    God bless!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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