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