Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Have "Freeze Pane" button track current state | Excel Programming | |||
Excel loses "Freeze Panes" setting | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |