Solved

macro code to bring  an excel  sheet to the front

Posted on 2014-09-11
1
366 Views
Last Modified: 2014-09-12
Hi Experts,

    I am writing an excel macro . In the middle when macro runs ,  I open another excel file   thru the macro  ( And then a routine in macro runs that takes sometime )  My problem is , the Original sheet which called the macro is now in the back

    How can bring my original sheet  to the front ?

 Sam
0
Comment
Question by:Sam OZ
1 Comment
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40318686
Hi,

pls try

ThisWorkbook.Activate

Regards
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question