software

I have a workbook (named Form.xls) with a number of macros, each of which is
assigned to a button on a custom toolbar. I import data from another program
into this workbook, then use the macros to format the data into Customized
Reports. I want to then save the workbook with a new name (I use today's date
as the name, eg 03.29.06) so that I have an archive of the reports produced.

My problem is that when I use File, Save As to rename Form.xls, the Toolbar
buttons in Form.xls all change their assignments to the new file's name. So
the next time I open Form.xls, the new file (ie 03.29.06) also opens so that
the macros are available.

Is there a way to avoid having this re-assignment occur?

Thanks
--
- markvi

Build your toolbar when the workbook is opened and destroy it when the workbook
is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

markvi wrote:
gt;
gt; I have a workbook (named Form.xls) with a number of macros, each of which is
gt; assigned to a button on a custom toolbar. I import data from another program
gt; into this workbook, then use the macros to format the data into Customized
gt; Reports. I want to then save the workbook with a new name (I use today's date
gt; as the name, eg 03.29.06) so that I have an archive of the reports produced.
gt;
gt; My problem is that when I use File, Save As to rename Form.xls, the Toolbar
gt; buttons in Form.xls all change their assignments to the new file's name. So
gt; the next time I open Form.xls, the new file (ie 03.29.06) also opens so that
gt; the macros are available.
gt;
gt; Is there a way to avoid having this re-assignment occur?
gt;
gt; Thanks
gt; --
gt; - markvi

--

Dave Peterson

Thanks Dave. (Sorry not to respond sooner - the email notification went into
my Spam folder.) This sounds as if it functions more or less as the personal
workbook macro file, but doesn't have to actually open every time you start
Excel. Busy time of the year for me right now, so I may not have a chance to
try all of this for a couple of weeks, but it seems to do all I was hoping
for.

Thanks again!
--
- markviquot;Dave Petersonquot; wrote:

gt; Build your toolbar when the workbook is opened and destroy it when the workbook
gt; is closed.
gt;
gt; For additions to the worksheet menu bar, I really like the way John Walkenbach
gt; does it in his menumaker workbook:
gt; j-walk.com/ss/excel/tips/tip53.htm
gt;
gt; Here's how I do it when I want a toolbar:
gt; www.contextures.com/xlToolbar02.html
gt; (from Debra Dalgleish's site)
gt;
gt; markvi wrote:
gt; gt;
gt; gt; I have a workbook (named Form.xls) with a number of macros, each of which is
gt; gt; assigned to a button on a custom toolbar. I import data from another program
gt; gt; into this workbook, then use the macros to format the data into Customized
gt; gt; Reports. I want to then save the workbook with a new name (I use today's date
gt; gt; as the name, eg 03.29.06) so that I have an archive of the reports produced.
gt; gt;
gt; gt; My problem is that when I use File, Save As to rename Form.xls, the Toolbar
gt; gt; buttons in Form.xls all change their assignments to the new file's name. So
gt; gt; the next time I open Form.xls, the new file (ie 03.29.06) also opens so that
gt; gt; the macros are available.
gt; gt;
gt; gt; Is there a way to avoid having this re-assignment occur?
gt; gt;
gt; gt; Thanks
gt; gt; --
gt; gt; - markvi
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Glad you got it working.

markvi wrote:
gt;
gt; Thanks Dave. (Sorry not to respond sooner - the email notification went into
gt; my Spam folder.) This sounds as if it functions more or less as the personal
gt; workbook macro file, but doesn't have to actually open every time you start
gt; Excel. Busy time of the year for me right now, so I may not have a chance to
gt; try all of this for a couple of weeks, but it seems to do all I was hoping
gt; for.
gt;
gt; Thanks again!
gt; --
gt; - markvi
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Build your toolbar when the workbook is opened and destroy it when the workbook
gt; gt; is closed.
gt; gt;
gt; gt; For additions to the worksheet menu bar, I really like the way John Walkenbach
gt; gt; does it in his menumaker workbook:
gt; gt; j-walk.com/ss/excel/tips/tip53.htm
gt; gt;
gt; gt; Here's how I do it when I want a toolbar:
gt; gt; www.contextures.com/xlToolbar02.html
gt; gt; (from Debra Dalgleish's site)
gt; gt;
gt; gt; markvi wrote:
gt; gt; gt;
gt; gt; gt; I have a workbook (named Form.xls) with a number of macros, each of which is
gt; gt; gt; assigned to a button on a custom toolbar. I import data from another program
gt; gt; gt; into this workbook, then use the macros to format the data into Customized
gt; gt; gt; Reports. I want to then save the workbook with a new name (I use today's date
gt; gt; gt; as the name, eg 03.29.06) so that I have an archive of the reports produced.
gt; gt; gt;
gt; gt; gt; My problem is that when I use File, Save As to rename Form.xls, the Toolbar
gt; gt; gt; buttons in Form.xls all change their assignments to the new file's name. So
gt; gt; gt; the next time I open Form.xls, the new file (ie 03.29.06) also opens so that
gt; gt; gt; the macros are available.
gt; gt; gt;
gt; gt; gt; Is there a way to avoid having this re-assignment occur?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt; --
gt; gt; gt; - markvi
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson