Solved

macro code to bring  an excel  sheet to the front

Posted on 2014-09-11
1
436 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 50

Accepted Solution

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

pls try

ThisWorkbook.Activate

Regards
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
countHi challenge 25 179
array6 challenfge 6 120
Where did System.Data.Objects go? 2 60
Math Equation 23 126
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
Navigation is an important part of web design from a usability perspective. But it is often a pain when it comes to a developer’s perspective. By navigation, it often means menuing. This is less theory and more practical of how to get a specific gro…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
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…

733 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