Results 1 to 3 of 3

ThisWorkbook doubt

Threaded View

amandeepsharma89 ThisWorkbook doubt 05-30-2012, 11:43 AM
JosephP Re: ThisWorkbook doubt 05-30-2012, 11:45 AM
amandeepsharma89 Re: ThisWorkbook doubt 05-30-2012, 11:49 AM
  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.

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