Results 1 to 8 of 8

Generate a "Workbook Open" Macro in new worksheet Programmaticly

Threaded View

TheNewGuy Generate a "Workbook Open"... 03-10-2010, 09:11 AM
JeanRage Re: Generate a "Workbook... 03-10-2010, 09:15 AM
romperstomper Re: Generate a "Workbook... 03-10-2010, 09:22 AM
TheNewGuy Re: Generate a "Workbook... 03-10-2010, 09:35 AM
dominicb Re: Generate a "Workbook... 03-10-2010, 09:51 AM
romperstomper Re: Generate a "Workbook... 03-10-2010, 10:02 AM
TheNewGuy Re: Generate a "Workbook... 03-10-2010, 09:57 AM
TheNewGuy Re: Generate a "Workbook... 03-10-2010, 10:33 AM
  1. #1
    Forum Contributor
    Join Date
    06-01-2009
    Location
    Cincinatti,Ohio
    MS-Off Ver
    Excel 2003
    Posts
    122

    Generate a "Workbook Open" Macro in new worksheet Programmaticly

    Hello, I have searched to find the answer myself but I just can't seem to find what I am looking for. I have a LARGE Workbook that I call a "Program" because it has lots of Userforms that I use to enter data in and then at the end it generates a new Workbook based on what I typed in all without the user ever even seeing an excel workbook,worksheet, or cell.
    One of the worksheets generated in this new workbook is what i call the "CONFIG" sheet and I use as a "CONFIG" file so that at a later date I can use the new workbook to re-load all that data back into my "Program" so I can generate a different workbook with it and not have to type all that data back in.....I hope that made sense..anyway all i need is a way to add a
    Public Sub Workbook_Open()
    Sheets("CONFIG").Visible = false
    end sub
    to the new workbook automatically when the Macro generates it the first time. So that the user of the new workbook does not see it. If you have any questions let me know.
    Thank you for your time,
    Last edited by TheNewGuy; 03-10-2010 at 10:51 AM.

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