To "freeze" Spreadsheet
 

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

To "freeze" Spreadsheet
 

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)



On Sat, 1 Aug 2009 13:03:01 -0700, Daniel Utsch
wrote:

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