MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro Help


Posted by Mark Kennedy on January 17, 2002 11:19 AM

Hello-
I want to add a snippet of code to an existing macro that will take me back to my original sheet. My macro makes some changes and ends up on a new sheet. I want it to take me back to whatever sheet I was on when I envoked the macro.
I know this has to be so simple. I just don't have time to do it.
Any help would be greatly appreciated.
Thanks,
Mark


Posted by Dan on January 17, 2002 11:38 AM

At the beginning of your macro put:
WorkbookName = ActiveWorkbook.Name

at the end put:
Windows(WorkbookName).Activate

that should work for you...HTH

Posted by Dan on January 17, 2002 12:03 PM

Almost forgot to tell you to declare the WorkbookName variable as a String first.

Dim WorkbookName as String

Posted by Mark on January 17, 2002 12:26 PM

Posted by Mark on January 17, 2002 12:27 PM

That's it! Thanks for your help! This is the first time I've used this site. What an awesome resource! I'll be back.