New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

VBA Code to Detect Multiple Windows Open

Macros, VBA, Excel Automation, etc.

VBA Code to Detect Multiple Windows Open

Postby Peg Molter » Tue Feb 16, 2016 1:58 pm

Can someone suggest to me how to write a conditional statement that looks to find out if there are multiple windows open for a given workbook. i.e., If (more than one window for a workbook is open), Then (activate [this sheet] on Copy 1).

I can write the code to deal with 2 copies of a workbook being open. Problem is, I don't know that that's always going to be the case. So I need to test for that, do one thing if more than one copy is open, and do something else if only one copy is open.

Thanks.

Peg
  • 0

Peg Molter
Rookie
 
Posts: 1
Joined: Feb 16, 2016
Reputation: 0
Excel Version: 2013

Re: VBA Code to Detect Multiple Windows Open

Postby pecoflyer » Tue Feb 16, 2016 2:31 pm

Hi and welcome

I have no idea if this will help http://www.rondebruin.nl/win/s9/win003.htm
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 73 guests

cron