How to Activate a Specific Workbooks in Excel Using VBA

Activate Workbook or Worksheet

If you know the name of the workbook You can use the following code to Activate Workbook or worksheet. For example workbook name is “Book2” which we want to activate and it contains sheet named as “Sheet1”. Using following code you can Activate Workbook Or Work Sheet.

 

Code:

 

Sub Activate_Workbook()

    
    'Activate Workbook
    Workbooks("Book2.xls").Activate   

    'Activate Worksheet
    Workbooks("Book2.xls").Sheets("Sheet1").Activate



End Sub

 

VBA Activate Worksheet –

Please see the below VBA codes to activate Worksheet. In this example we are activating a Worksheet named “Project1”.

Sub Activate_Sheet()


    Worksheets("Project1").Activate
    'Or
    Sheets("Project1").Activate


End Sub

VBA Activate Worksheet Method– with Number: Example 2

Please see the below VBA code or macro procedure to activate Worksheet. In this example we are activating first Worksheet in the active workbook.

Sub Activate_Sheet_BasedOnIndex()


    Worksheets(1).Activate
    'Or
    Sheets(1).Activate


End Sub

 

 

 

 

 

Share This Post

56 comments

  • Some times its a pain in the ass to read what people wrote but this internet site is really user friendly! .

  • (Google News) – Easy Bleeding and Bruising. Your liver makes the things that help your blood clot. When it’s damaged, it can’t make good enough. You superiority start to bleed surely and comprise irk stopping it. Or you muscle blotch easily. Tell your dentist or other doctors in the vanguard you have any modafinil online pharmacy medical procedure. Treat cuts with strength bandages and go to to the doctor right away. In an predicament, you’ll get platelets to restore what you helpless and Vitamin K to helper your blood clot.
    Updated: July 30, 2019 17:32

  • Ovulation – Ovulation is anyone of the biggest and the most common apology behind a better half not being able to conceive. This limited working order can be triggered by way of profuse sub-conditions, one of the prime reasons being generic viagra. Other on conditions suggest; primary ovarian insufficiency, thyroid dysfunction, being terminated and underweight, and unjustifiable exercise. A lady-love experiencing ovulation problems have inconsistent periods, unchanging despite the fact that conventional cycle does not bond ovulation to occur. January 3, 2019 11:10

  • I don’t consider that this is what innumerable people believe upon when adopting a dog, said Warraich, who was not involved with the new research. They think they’re doing it for the being, not in return their own robustness http://canadianpharmacymmx.com canada pharmacy online. But these studies bring up that adopting a dog may be as much of a professional care to your own health as the dog’s. Restful, Warraich said, it’s not tolerably to possess me suggest patients take a dog to deign their endanger of death. Representing that to happen, prescription drugs from canada there would prerequisite to be a drawing lots more investigate, he noted.

  • (Google News) – Do not do the trick grapefruit or grapefruit juice while winsome viagra prescription. If you are torment from any of the salubriousness problems like focus disorders, blood arm-twisting, diabetes, liver disorders, atherosclerosis, kidney problems, or ocular problems, etc. first go doctor’s advice ahead of bewitching looking for a doctor. Avoid leaden obesity meals in front entrancing this prescription as it retards its effect. April 22, 2019 5:41

  • [url=https://albuterol365.com/]otc albuterol[/url] [url=https://furosemide1.com/]furosemide 20 mg[/url] [url=https://sildenafilvg.com/]order sildenafil canada[/url] [url=https://furosemidetab.com/]furosemide 25 mg[/url] [url=https://zoloft24.com/]zoloft 50 mg[/url] [url=https://furosemidelab.com/]furosemide 40 mg tablet cost[/url] [url=https://lisinoprilhcz.com/]lisinopril price[/url] [url=https://albendazole365.com/]albendazole buy canada[/url] [url=https://fluoxetine1000.com/]fluoxetine buy[/url] [url=https://ventolin911.com/]ventolin 200 mcg[/url]

  • [url=https://vardenafill.com/]vardenafil 20mg[/url]

  • [url=http://albuterol365.com/]buy albuterol over the counter[/url] [url=http://tadalafilcia.com/]tadalafil 20mg coupon[/url] [url=http://metformin360.com/]1000 mg metformin coupon pharmacy[/url] [url=http://prednisonetl.com/]order prednisone from canada[/url] [url=http://clomid150.com/]where to get clomid[/url]

  • [url=http://furosemide1.com/]furosemide 20 mg tablet[/url] [url=http://arimidexsale.com/]arimidex 1[/url] [url=http://doxycyclinehycl.com/]can i buy doxycycline over the counter[/url] [url=http://lisinoprilhcz.com/]lisinopril sale[/url] [url=http://ventolin911.com/]ventolin price in usa[/url] [url=http://diflucan5.com/]diflucan prescription[/url] [url=http://lisinoprilmd.com/]lisinopril 10 mg tablet[/url]

  • [url=https://wratotadaper.ml]wratotadaper.ml[/url]

  • [url=https://wratotadaper.ml]wratotadaper.ml[/url]

  • [url=https://wratotadaper.ml]wratotadaper.ml[/url]

  • [url=https://tadalafilcia.com/]tadalafil 20mg[/url]

  • [url=http://amoxicillincaps.com/]amoxicillin no script[/url] [url=http://vardenafill.com/]vardenafil hcl 20mg tab[/url] [url=http://prednisonetl.com/]prednisone medicine[/url] [url=http://ventolin911.com/]order ventolin[/url] [url=http://tadalafilcia.com/]tadalafil cost[/url] [url=http://prednisonester.com/]prednisone oral[/url] [url=http://doxycyclinehycl.com/]buy vibramycin[/url] [url=http://diflucan5.com/]where can i get diflucan[/url] [url=http://celebrexotc.com/]celebrex generic[/url] [url=http://accutanrx.com/]order accutane no prescription[/url] [url=http://zoloft24.com/]zoloft 50 mg[/url] [url=http://valtrex24.com/]buy valtrex online[/url] [url=http://sildenafilgen.com/]sildenafil 20 mg[/url] [url=http://diflucan10.com/]order diflucan online canada[/url] [url=http://levitramed.com/]buy genuine levitra online[/url] [url=http://lisinoprilmd.com/]lisinopril 10 mg[/url] [url=http://arimidexsale.com/]arimidex price[/url] [url=http://doxycycline20.com/]doxycycline 75 mg[/url] [url=http://albuterol365.com/]buy albuterol usa[/url] [url=http://furosemidetab.com/]furosemide otc[/url]

  • [url=https://diflucan10.com/]diflucan pill[/url] [url=https://albendazole365.com/]buy albendazole medicine[/url] [url=https://tadalafilcia.com/]tadalafil 3mg[/url] [url=https://doxycycline20.com/]doxycycline 100mg[/url] [url=https://ventolin911.com/]ventolin prescription discount[/url]

  • [url=http://celebrexotc.com/]price of celebrex 200 mg in south africa[/url] [url=http://sildenafilvg.com/]sildenafil 10 mg[/url] [url=http://accutanrx.com/]accutane for sale[/url] [url=http://prednisonetl.com/]generic prednisone 20mg[/url] [url=http://doxycyclinehycl.com/]buy doxycycline[/url] [url=http://tadalafilcia.com/]cheap tadalafil[/url] [url=http://diflucan10.com/]diflucan cream[/url] [url=http://valtrex24.com/]valtrex 1000 mg[/url] [url=http://lisinoprilmd.com/]lisinopril 10 mg[/url] [url=http://zoloft24.com/]400 mg zoloft[/url]

  • [url=https://avodart24.com/]buy generic avodart[/url] [url=https://tadalafilcia.com/]tadalafil 20mg india[/url] [url=https://sildenafilvg.com/]sildenafil canada cost[/url] [url=https://prednisonester.com/]prednisone 60 mg[/url] [url=https://lisinoprilmd.com/]lisinopril 10 mg[/url]

  • [url=http://avodart24.com/]avodart 500 mcg[/url] [url=http://fluoxetine1000.com/]fluoxetine 10mg tablets uk[/url] [url=http://levitramed.com/]prices levitra[/url] [url=http://lisinoprilhcz.com/]buying lisinopril in mexico[/url] [url=http://doxycycline20.com/]doxycycline generic[/url]

  • [url=https://lisinoprilhcz.com/]where to buy lisinopril online[/url] [url=https://fluoxetine1000.com/]fluoxetine 10 mg cost[/url]

  • [url=http://albendazole365.com/]albendazole tablet[/url]

  • [url=http://ventolin911.com/]ventolin pharmacy uk[/url] [url=http://doxycycline20.com/]doxycycline 200 mg tablets[/url] [url=http://avodart24.com/]avodart 0.5 mg uk[/url] [url=http://albuterol365.com/]albuterol prescription cost[/url] [url=http://furosemide1.com/]furosemide tablets[/url] [url=http://lisinoprilhcz.com/]lisinopril pill[/url] [url=http://furosemidelab.com/]furosemide cost comparison[/url] [url=http://tadalafilcia.com/]tadalafil 60 mg[/url] [url=http://avodartgen.com/]avodart 0 5mg[/url] [url=http://lisinoprilmd.com/]lisinopril 10 mg[/url] [url=http://diflucan10.com/]candida diflucan[/url] [url=http://metformin360.com/]metformin 500 mg coupon[/url] [url=http://amoxicillincaps.com/]amoxicillin 500mg buy online uk[/url] [url=http://levitramed.com/]levitra 20mg cost[/url] [url=http://sildenafilgen.com/]order sildenafil canada[/url] [url=http://furosemidetab.com/]furosemide 12.5 mg[/url] [url=http://albendazole365.com/]albendazole cost[/url] [url=http://fluoxetine1000.com/]fluoxetine 30 mg tablets[/url] [url=http://valtrex24.com/]buy valtrex online[/url] [url=http://prednisonetl.com/]buy prednisone online no prescription[/url]

  • Trump escalated his attacks on the whistleblower, demanding to meet his ‘accuser’ face to face online viagra vs prescription

  • [url=https://furosemidelab.com/]furosemide 40 mg pill[/url] [url=https://diflucan5.com/]how to get diflucan otc[/url] [url=https://furosemide1.com/]furosemide australia[/url] [url=https://fluoxetine1000.com/]fluoxetine 20 mg[/url]

  • [url=http://diflucan10.com/]diflucan pill[/url] [url=http://prednisonetl.com/]prednisone brand[/url] [url=http://diflucan5.com/]diflucan 150 mg[/url] [url=http://sildenafilgen.com/]sildenafil citrate tablets 100mg[/url] [url=http://clomid150.com/]clomid online purchase[/url]

  • [url=http://lisinoprilmd.com/]lisinopril tabs 20mg[/url]

  • [url=https://albuterol365.com/]albuterol price[/url] [url=https://furosemidetab.com/]furosemide cost[/url] [url=https://prednisonetl.com/]how to buy prednisone[/url] [url=https://furosemide1.com/]furosemide 20 mg tablet[/url] [url=https://avodartgen.com/]avodart tab price[/url] [url=https://tadalafilcia.com/]tadalafil cipla[/url] [url=https://vardenafill.com/]where to buy vardenafil online[/url] [url=https://sildenafilvg.com/]sildenafil generic price[/url]

  • [url=http://fluoxetine1000.com/]fluoxetine 10mg[/url]

  • [url=http://clomid150.com/]order clomid pills online[/url] [url=http://amoxicillincaps.com/]where can i get amoxicillin 500 mg[/url] [url=http://celebrexotc.com/]buy celebrex online uk[/url] [url=http://prednisonetl.com/]prednisone buy no prescription[/url] [url=http://lisinoprilhcz.com/]how to buy lisinopril online[/url] [url=http://sildenafilgen.com/]best online sildenafil[/url] [url=http://vardenafill.com/]vardenafil 20mg[/url] [url=http://ventolin911.com/]ventolin cost[/url] [url=http://doxycycline20.com/]can i buy doxycycline over the counter uk[/url] [url=http://arimidexsale.com/]buy arimidex[/url]

  • [url=http://amoxicillincaps.com/]amoxicillin prices[/url] [url=http://lisinoprilmd.com/]lisinopril 10 mg tablet[/url] [url=http://prednisonetl.com/]generic prednisone[/url] [url=http://arimidexsale.com/]arimidex men[/url] [url=http://furosemidetab.com/]furosemide pill[/url]

  • [url=https://vardenafill.com/]vardenafil price comparison[/url]

  • [url=http://lisinoprilmd.com/]lisinopril 40 mg tablet[/url] [url=http://zoloft24.com/]cost of zoloft in canada[/url] [url=http://arimidexsale.com/]arimidex brand name[/url] [url=http://doxycyclinehycl.com/]buy doxycycline 100mg capsules[/url]

  • [url=https://furosemidelab.com/]furosemide no prescription[/url] [url=https://doxycycline20.com/]doxycycline 100mg[/url] [url=https://albendazole365.com/]albendazole 200 mg[/url] [url=https://clomid150.com/]clomid 25mg[/url] [url=https://sildenafilgen.com/]where to buy sildenafil[/url]

  • [url=https://arimidexsale.com/]average price of arimidex[/url] [url=https://furosemide1.com/]buy furosemide 40 mg online uk[/url]

  • [url=https://vardenafill.com/]price of vardenafil[/url] [url=https://lisinoprilmd.com/]lisinopril 10 mg[/url]

  • [url=http://vardenafill.com/]vardenafil generic[/url]

  • [url=https://sildenafilvg.com/]sildenafil 50 mg cost[/url]

  • [url=https://avodartgen.com/]avodart capsule[/url] [url=https://avodart24.com/]avodart 0.4 mg[/url] [url=https://lisinoprilhcz.com/]generic lisinopril 5 mg[/url] [url=https://doxycycline20.com/]doxycycline 100mg cost[/url] [url=https://tadalafilcia.com/]where to buy tadalafil in singapore[/url] [url=https://furosemide1.com/]buy furosemide[/url] [url=https://prednisonetl.com/]prednisone coupon[/url]

  • [url=http://prednisonester.com/]prednisone in canada[/url] [url=http://diflucan10.com/]canadian pharmacy diflucan[/url] [url=http://furosemidetab.com/]furosemide pill[/url] [url=http://furosemide1.com/]furosemide tablets[/url] [url=http://doxycycline20.com/]doxycycline 100mg for sale[/url]

  • [url=https://lisinoprilhcz.com/]buy lisinopril[/url] [url=https://prednisonester.com/]where can you buy prednisone[/url] [url=https://tadalafilcia.com/]tadalafil 3mg[/url] [url=https://amoxicillincaps.com/]amoxicillin 500 mg[/url] [url=https://doxycyclinehycl.com/]buy doxycycline pills online[/url]

  • [url=http://ventolin911.com/]buy ventolin over the counter uk[/url] [url=http://diflucan10.com/]diflucan pill[/url] [url=http://arimidexsale.com/]buy arimidex[/url] [url=http://furosemide1.com/]buy furosemide 20 mg online[/url] [url=http://levitramed.com/]levitra cost[/url] [url=http://sildenafilvg.com/]cheapest sildenafil online[/url] [url=http://albendazole365.com/]albendozale purchase[/url] [url=http://vardenafill.com/]vardenafil 20 mg canada[/url] [url=http://celebrexotc.com/]celebrex generic cost[/url] [url=http://amoxicillincaps.com/]where to buy amoxicillin 500mg without prescription[/url]

  • I know this if off topic but I’m looking into starting my own blog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100% sure. Any recommendations or advice would be greatly appreciated. Appreciate it viagra online without prescription

  • [url=https://valtrex24.com/]cost for valtrex[/url]

  • [url=http://furosemidetab.com/]furosemide cost us[/url]

  • [url=https://celebrexotc.com/]buy celebrex[/url] [url=https://valtrex24.com/]valtrex otc[/url] [url=https://sildenafilgen.com/]buy sildenafil generic canada[/url] [url=https://doxycycline20.com/]doxycycline 100mg tablets[/url]

  • [url=https://levitramed.com/]generic levitra online canada[/url]

  • [url=https://diflucan10.com/]diflucan tablet[/url] [url=https://furosemide1.com/]furosemide 20 mg[/url] [url=https://albuterol365.com/]albuterol price[/url] [url=https://arimidexsale.com/]arimidex prescription[/url] [url=https://valtrex24.com/]buy valtrex online prescription[/url] [url=https://doxycycline20.com/]where can i get doxycycline over the counter[/url] [url=https://furosemidetab.com/]furosemide pill[/url] [url=https://metformin360.com/]metformin 500 mg[/url] [url=https://accutanrx.com/]accutane cream[/url] [url=https://albendazole365.com/]albendazole 400 mg[/url]

  • [url=http://avodartgen.com/]avodart for sale uk[/url] [url=http://prednisonester.com/]prednisone 5[/url] [url=http://albuterol365.com/]albuterol pills[/url] [url=http://celebrexotc.com/]buy celebrex[/url] [url=http://lisinoprilhcz.com/]buy lisinopril[/url]

  • [url=https://albendazole365.com/]albendazole drug[/url] [url=https://accutanrx.com/]cost of accutane in canada[/url] [url=https://avodartgen.com/]avodart generic costs[/url] [url=https://diflucan5.com/]diflucan 150 mg[/url] [url=https://furosemide1.com/]furosemide 80 mg tablet[/url]

  • [url=http://furosemidelab.com/]furosemide 40 mg price[/url]

  • [url=http://zoloft24.com/]zoloft generic cost 25mg[/url] [url=http://prednisonetl.com/]buy prednisone online from mexico[/url] [url=http://albuterol365.com/]albuterol 2[/url] [url=http://accutanrx.com/]accutane singapore[/url] [url=http://clomid150.com/]clomid coupon[/url] [url=http://furosemidelab.com/]furosemide 40 mg daily[/url] [url=http://arimidexsale.com/]arimidex brand[/url] [url=http://lisinoprilmd.com/]lisinopril otc[/url] [url=http://fluoxetine1000.com/]fluoxetine cap 40mg[/url] [url=http://vardenafill.com/]vardenafil generic[/url]

  • [url=https://levitramed.com/]generic levitra price[/url] [url=https://albendazole365.com/]buy albendazole medicine[/url] [url=https://vardenafill.com/]vardenafil for women[/url] [url=https://lisinoprilmd.com/]lisinopril 5 mg tablet price[/url] [url=https://sildenafilgen.com/]sildenafil generic[/url] [url=https://metformin360.com/]metformin 1500 mg[/url] [url=https://avodartgen.com/]avodart .5mg price[/url] [url=https://accutanrx.com/]accutane generic[/url]

  • [url=http://diflucan5.com/]diflucan 200 mg price south africa[/url] [url=http://arimidexsale.com/]buy arimidex 1mg[/url] [url=http://tadalafilcia.com/]tadalafil 20mg india[/url] [url=http://doxycyclinehycl.com/]can you buy doxycycline[/url] [url=http://levitramed.com/]generic levitra price[/url]

  • [url=https://vardenafill.com/]buy vardenafil online cheap[/url] [url=https://metformin360.com/]metformin 500 mg tablet price[/url] [url=https://accutanrx.com/]accutane 20 mg[/url] [url=https://sildenafilvg.com/]sildenafil 50mg tablets[/url]

  • What i don’t realize is actually how you’re not actually much more well-liked than you may be right now. You’re very intelligent. You realize thus significantly relating to this subject, made me personally consider it from numerous varied angles. Its like men and women aren’t fascinated unless it is one thing to do with Lady gaga! Your own stuffs excellent. Always maintain it up! viagra without dr prescription

  • [url=https://avodart24.com/]avodart 5 mg[/url]

  • [url=http://albuterol365.com/]albuterol 0.5[/url] [url=http://zoloft24.com/]cost of zoloft 50 mg[/url] [url=http://celebrexotc.com/]buy celebrex[/url] [url=http://ventolin911.com/]ventolin medication[/url] [url=http://sildenafilvg.com/]sildenafil 20 mg cost[/url]

Leave a Reply

Your email address will not be published.