Solved

macro code to bring  an excel  sheet to the front

Posted on 2014-09-11
1
316 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 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

pls try

ThisWorkbook.Activate

Regards
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
constructor while deserilizing object 16 51
tripleUp challenge 7 65
fix34  challenge 9 95
Re-position the objects 7 46
With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now