ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   stop VBA (https://www.excelbanter.com/excel-programming/406425-stop-vba.html)

Souris

stop VBA
 
I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


Mike H

stop VBA
 
Don't enable macros when you start and you code can't go into an endless loop

Mike

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


FSt1

stop VBA
 
hi
to stop a run away loop, hit the emergency stop buttons....
Ctrl + Break.

regards
FSt1

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


Souris

stop VBA
 
Thanks millions for helping,

"FSt1" wrote:

hi
to stop a run away loop, hit the emergency stop buttons....
Ctrl + Break.

regards
FSt1

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


Souris

stop VBA
 
Thanks millions for helping,

"Mike H" wrote:

Don't enable macros when you start and you code can't go into an endless loop

Mike

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


Patrick Molloy[_2_]

stop VBA
 
to open a workbook without the code running, hold down the SHIFT key when to
click the open button

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,


Souris

stop VBA
 
Thanks,

wow, there are many solutions for this,

Thanks again,

"Patrick Molloy" wrote:

to open a workbook without the code running, hold down the SHIFT key when to
click the open button

"Souris" wrote:

I have endless loop n my VBA on open workbook by mistake.

It runs when open spreadsheet.

Are there any way to open speadsheet without running open work book to
modify and debug my VBA code?


Your help is great appreciated,



All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com