How to fix Excel’s hanging issues which started recently after a new action

[bittubadri]

Recently, I have started facing ‘troubling issues’ with my Workbook getting ‘hanged’, Worksheets flickering & the arrow cursor turning in to a blue spinning ball. These issue remains for a specified time period I.e it starts when now>= 07-25-2022 9:15:00 AM & remains up to now<07-25-2022 10:00:00 AM i.e. from 9:15 till 10:00 whenever the Workbook is kept opened. As soon as now>=10:00, all these ‘troubles’ vanishes & the all ws in the Workbook functions normal.

Here I need to mention that all these ‘troubling issues’ with my Workbook started from the time I inserted a new Worksheet (in this same Workbook) & in the Module I pasted a ‘new vb code’.

I also found that when I delete the ‘new vb code’ from the Module & use the remaining Workbook, these ‘troubling issues’ vanishes.

The new vb code has a For Next loop whose counter is “i”. The lines of this new vb code are:

Please Login or Register  to view this content.

For another 12 ws, I am using a code pasted in ThisWorkbook which has the vb code:

Please Login or Register  to view this content.

My query is;
1. Is the same variant being used in both codes causing these ‘troubling issues’, if yes, what is the remedy?
2. Should I make the counter “i” in the new vb code Worksheet specific i.e. its action should remain confined to the new ws only? If yes, how to make it confined to the new ws only?
3. Any other help so that I can get rid of the new ‘troubling issues’?

Any help provided would be appreciated.

[TMS]

1. Is the same variant being used in both codes causing these ?troubling issues?, if yes, what is the remedy?
2. Should I make the counter ?i? in the new vb code Worksheet specific i.e. its action should remain confined to the new ws only? If yes, how to make it confined to the new ws only?
3. Any other help so that I can get rid of the new ?troubling issues??

1. I don't know what this means. The Workbook_BeforeSave code will only be executed when the workbook is saved. So, do you save the workbook in code elsewhere?
2. The variable is defined within the Workbook_BeforeSave routine. There is no indication if, where, or how the variable i is defined in the new code. However, by default, it will be local to the new code.
3. You are not showing any code that appears to relate to dates and times so it is not obvious where this causes issues.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[beyond Excel]

Any help provided would be appreciated.

Take advantage of the fact that you will attach your file and explain to us what you wanted to do with what you call "new vb code" because it seems that it is not well programmed.

[bebo021999]

Maybe try to remove the line

n=n-1  

in the new vb code