+ Reply to Thread
Results 1 to 3 of 3

ThisWorkbook doubt

  1. #1
    Registered User
    Join Date
    05-21-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    75

    ThisWorkbook doubt

    Hello Seniors,
    I have a line of code as follows

    ThisWorkbook.Greencard = True

    My question is, is "Greencard" a name of the sheet and if it is what does the above code do

    The entire finction is as follows


    Private Sub btnGreenCards_Click()
    GreencardReport
    ThisWorkbook.GreenCard = True
    End Sub

    In my excels spreadsheet there is no sheet named GreenCard there is one named Green Cards. I am in a fix please help me out.
    Waiting for replies

    Regards,
    Amandeep
    Last edited by amandeepsharma89; 05-30-2012 at 04:48 PM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: ThisWorkbook doubt

    greencard is either a variable or a property (boolean in either case) declared in the ThisWorkbook module of your workbook.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    05-21-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: ThisWorkbook doubt

    Joseph,
    Spot on!! Awesome its in the place that you described. I was stuck in this since an hour and then decided to post it here. Solved my problem in a minute. This forum rocks and its because of Thanks a ton JP.

    Regards,
    Amandeep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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