Results 1 to 3 of 3

Thread: Create new worksheet from template file in Excel

  1. Oct 25th, 2006, 01:59 PM #1
    Garrett
    Garrett is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2001
    Posts
    142

    Question Create new worksheet from template file in Excel

    I am trying to figure out how to do the following:

    In an existing workbook, double click a specific cell which will load a specific template file into a new worksheet and name the new tab the same as the text that was in the cell I double clicked.

    Any help is appriciated.

    Thank you,
    Garrett
    Last edited by Garrett; Oct 25th, 2006 at 02:34 PM.
    Reply With Quote Reply With Quote
  2. Oct 26th, 2006, 03:06 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Create new worksheet from template file in Excel

    You'd need to capture the double click event on the cell.
    Verify that the cell has a name.
    Verify that the sheet name doesn't already exist.
    Open the template.
    Copy the sheet (renaming as you go).

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Oct 26th, 2006, 09:15 AM #3
    Garrett
    Garrett is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2001
    Posts
    142

    Re: Create new worksheet from template file in Excel

    Thanks Ecniv.
    Does anyone have any examples or a site that I can learn from? I'm new to VB in excel.
    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width