+ Reply to Thread
Results 1 to 4 of 4

excel template inherit

  1. #1
    mmcc128@gmail.com
    Guest

    excel template inherit

    Is there a way (maybe a setting) that will make worksheets inherit
    changes of the template that they were created from?

    So, if I were to modify the template - all of its "children" would also
    be modified?


  2. #2
    Doug Kanter
    Guest

    Re: excel template inherit

    <mmcc128@gmail.com> wrote in message
    news:1146671008.457296.148190@y43g2000cwc.googlegroups.com...
    > Is there a way (maybe a setting) that will make worksheets inherit
    > changes of the template that they were created from?
    >
    > So, if I were to modify the template - all of its "children" would also
    > be modified?
    >



    That would be extremely useful! If nobody responds with that exact
    solution, perhaps this would work: Record a macro as you make changes to one
    of the "children", and then modify it as necessary so it works generically
    for any sheet, instead of just the one you were working on. Attach the code
    to a toolbar button. This assumes, of course, that all cell locations where
    changes occur are identical in all sheets.



  3. #3
    Chip Pearson
    Guest

    Re: excel template inherit

    Unlike Word, there is no link between a workbook and the template
    from which it was created. There is no way that changes made to
    the template file will change the workbooks which are based on
    the template.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    <mmcc128@gmail.com> wrote in message
    news:1146671008.457296.148190@y43g2000cwc.googlegroups.com...
    > Is there a way (maybe a setting) that will make worksheets
    > inherit
    > changes of the template that they were created from?
    >
    > So, if I were to modify the template - all of its "children"
    > would also
    > be modified?
    >




  4. #4
    Doug Kanter
    Guest

    Re: excel template inherit

    Using VBA, is there a way to scan every cell in a workbook or template,
    determine what formats are in place, and assign variables to each bit of
    information?


    "Chip Pearson" <chip@cpearson.com> wrote in message
    news:On1oZ5ubGHA.1208@TK2MSFTNGP02.phx.gbl...
    > Unlike Word, there is no link between a workbook and the template from
    > which it was created. There is no way that changes made to the template
    > file will change the workbooks which are based on the template.
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > <mmcc128@gmail.com> wrote in message
    > news:1146671008.457296.148190@y43g2000cwc.googlegroups.com...
    >> Is there a way (maybe a setting) that will make worksheets inherit
    >> changes of the template that they were created from?
    >>
    >> So, if I were to modify the template - all of its "children" would also
    >> be modified?
    >>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1