To "freeze" Spreadsheet

[Daniel Utsch]

Does anybody know as "freezing", the spreadsheet, in the moment of the
execution of a macro? I already tried :

Application.ScreenUpdating = False
Application.EnableAnimations = False

but the commandButtons of the Spreadsheet don't freeze when to macro this in
processing.

Thanks
Daniel Utsch

 

[Chip Pearson]

You can use the LockWindowUpdate Windows API function. E.g.,

Public Declare Function LockWindowUpdate Lib "user32" _
(ByVal HWnd As Long) As Long

Sub AAA()
LockWindowUpdate Application.HWnd
' your code here
LockWindowUpdate 0&
End Sub

Just be *SURE* that you have error trapping logic in place that
ensures that the window will be unlocked with

LockWindowUpdate 0&

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)