| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump out of Do Loop on sheet change
Hello All
In Office XP I have a separate Do Loop code running for each of 3 sheets. I would like the Do Loop code for a sheet to run only if that sheet is visible. I would like to jump out of the do loop on a sheet change. Right now when I exit a sheet the code for that sheet keeps going. Any suggestions would be much appreciated Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump out of Do Loop on sheet change
do while true
if activesheet.Name < me.name then exit sub doevents Loop -- Regards, Tom Ogilvy "Paul" wrote in message .rogers.com... Hello All In Office XP I have a separate Do Loop code running for each of 3 sheets. I would like the Do Loop code for a sheet to run only if that sheet is visible. I would like to jump out of the do loop on a sheet change. Right now when I exit a sheet the code for that sheet keeps going. Any suggestions would be much appreciated Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump out of Do Loop on sheet change
Thank you Tom
Paul -----Original Message----- do while true if activesheet.Name < me.name then exit sub doevents Loop -- Regards, Tom Ogilvy "Paul" wrote in message news:dLAoc.1154 ... Hello All In Office XP I have a separate Do Loop code running for each of 3 sheets. I would like the Do Loop code for a sheet to run only if that sheet is visible. I would like to jump out of the do loop on a sheet change. Right now when I exit a sheet the code for that sheet keeps going. Any suggestions would be much appreciated Paul . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINK - Jump to another sheet in the same workbook | Excel Worksheet Functions | |||
| jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
| macro that can jump to a sheet... | Excel Discussion (Misc queries) | |||
| Jump to Sheet Dropdown List | Excel Worksheet Functions | |||
| How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
Linear Mode
