Why does executing code containing 'Application. ScreenUpdating=false' in a workbook (including VBA) cause Dropdownlists in other worksheets to lose focus?

Question

Why does executing code containing 'Application. ScreenUpdating=false' in a workbook (including VBA) cause Dropdownlists in other worksheets to lose focus?

Anonymous

After upgrading from Office to Microsoft 365 (2402), I executed a function with the code "Application. ScreenUpdating=false" in workbook A containing VBA, which finally executed "Application. ScreenUpdating=true".

Found another dropdown list in Excel document B that cannot be focused properly. As follows:

NG2

The above issue does not exist in versions such as Office 2019, and if the "Application. ScreenUpdating=false" in workbook A is changed to "Application. ScreenUpdating=true", it will not cause the dropdown list in worksheet B to lose focus.

Please explain why this phenomenon occurs and whether it is a bug in Microsoft 365 (2402)?

Anonymous

2024-10-15T07:22:55.35+00:00

Hi,

Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description, your question is not in our support scope. So, we will remove teams tag from your thread. Thanks for your understanding and patience!
Anonymous

2024-10-16T08:55:34.0333333+00:00

Supplement to the above question:

I opened multiple workbooks containing and not containing VBA at the same time. When I executed the function with code "Application. ScreenUpdated=false" in workbook A containing VBA and the function ultimately executed "Application. ScreenUpdated=true", all the dropdown lists in other workbooks not containing VBA could not be focused properly.

When I closed and reopened all these workbooks, the dropdown lists in all workbooks returned to normal focus.

1 answer

Your answer

Anonymous

2024-10-15T07:22:55.35+00:00

Hi,

Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. According to your description, your question is not in our support scope. So, we will remove teams tag from your thread. Thanks for your understanding and patience!
Anonymous

2024-10-16T08:55:34.0333333+00:00

Supplement to the above question:

I opened multiple workbooks containing and not containing VBA at the same time. When I executed the function with code "Application. ScreenUpdated=false" in workbook A containing VBA and the function ultimately executed "Application. ScreenUpdated=true", all the dropdown lists in other workbooks not containing VBA could not be focused properly.

When I closed and reopened all these workbooks, the dropdown lists in all workbooks returned to normal focus.

Answer 1

Anonymous

add comment.

Share via

Why does executing code containing 'Application. ScreenUpdating=false' in a workbook (including VBA) cause Dropdownlists in other worksheets to lose focus?

1 answer

Your answer