+ Reply to Thread
Results 1 to 2 of 2

Move code from Sheet to ThisWorkbook/Module

  1. #1
    Forum Contributor
    Join Date
    07-07-2014
    Location
    Nottingham
    MS-Off Ver
    Office 2016
    Posts
    355

    Move code from Sheet to ThisWorkbook/Module

    I have the attached workbook which I have had help on with the code.

    I now need to look at moving some of the code from Sheet to either ThisWorkbook or Module. The idea of this workbook will be that I will have all of our staff sick episodes on individual worksheets, so i understand the need to not have too much code on a worksheet and copied every time, so if someone could point me in the right direction please.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-07-2014
    Location
    Nottingham
    MS-Off Ver
    Office 2016
    Posts
    355

    Re: Move code from Sheet to ThisWorkbook/Module

    Code I have so far is:

    SHEET1

    Please Login or Register  to view this content.

    THISWORKBOOK

    Please Login or Register  to view this content.

    MODULE1

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Specifying a sheet & range in ThisWorkbook module
    By vwhite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2018, 09:49 AM
  2. .xla ThisWorkbook module generates code on save
    By ignominousicon17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2018, 06:07 PM
  3. Difference between sheet, module and thisworkbook in excel
    By elfor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2017, 09:50 AM
  4. how to access Sheet module, normal module, Worbook module to type code
    By alibaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2009, 07:51 AM
  5. Code in 'ThisWorkbook' module in add-in?
    By karan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-04-2009, 03:36 AM
  6. [SOLVED] Can I add code to ThisWorkbook module with VBA extensibility?
    By mikeb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2006, 11:15 PM
  7. [SOLVED] Calls from sheet module to ThisWorkbook module
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM

Tags for this Thread

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