Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
events=false not acting?
trying to stop screen flicker with application events doesn't do it. the copy
and paste have done with auto filter etc. Have 8 other macros that do this same action. They run one after the other till done. So screen flicker is vivid. Screenupdateing is rejected. If I get this one can apply to other 8. Thanks for any assistance Sub One() ' One Macro ' Macro recorded 9/28/2007 by Curtiss A. Greer 'Application.EnableEvents = False 'Application.screenupdateing = False Range("D4").AutoFilter Field:=1, Criteria1:="1 Horses" ' Application.EnableEvents = False Range("A1:N104").Copy Application.EnableEvents = False Sheets("1").Select Range("A1").Select ActiveSheet.Paste ' Application.EnableEvents = True Columns("E:L").ClearContents Columns("A:A").ColumnWidth = 3.57 Columns("B:B").ColumnWidth = 11.29 Columns("C:C").ColumnWidth = 22.43 Columns("D:D").ColumnWidth = 15.14 Application.CutCopyMode = False Range("G14").Select Sheets("Data").Select Selection.AutoFilter Application.EnableEvents = True 'Application.screenupdateing = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
events=false not acting?
You have a spelling error!
Application.ScreenUpdating = False Check your settings on the Editor tab in the Tools|Options dialog box in the VBA editor. You should have the following options all checked: "Require Variable Declaration" "Auto List Members" "Auto Quick Info" "Auto Data Tips" (Turn off the option for "Auto Syntax Check" to avoid the constant error message dialog box that pops up every time you leave an unfinished line of code to go copy and paste something from another line.) Use Ctrl+J to pull down the methods/properties drop-down combo box. Then type the first few letters of Application and then scroll down to it and hit <Tab. Then type the period, at which time the list of methods and properties should then be shown again. Scroll down until you see ScreenUpdating, hit <Tab again to fill it in to your code editor window. Type the equal sign and another list with either False or True will display. Check the "Code Window General Use Keys" Help Topic in Visual Basic User Interface Help. At least in Excel 2000 and before, I think Microsoft did not do a very good job of explaining how to really use these features in the editor. Most of us have probably learned it piece-meal the hard way. -- Regards, Bill Renaud |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
events=false not acting?
Blind and can't see I guess
Thanks "Bill Renaud" wrote: You have a spelling error! Application.ScreenUpdating = False Check your settings on the Editor tab in the Tools|Options dialog box in the VBA editor. You should have the following options all checked: "Require Variable Declaration" "Auto List Members" "Auto Quick Info" "Auto Data Tips" (Turn off the option for "Auto Syntax Check" to avoid the constant error message dialog box that pops up every time you leave an unfinished line of code to go copy and paste something from another line.) Use Ctrl+J to pull down the methods/properties drop-down combo box. Then type the first few letters of Application and then scroll down to it and hit <Tab. Then type the period, at which time the list of methods and properties should then be shown again. Scroll down until you see ScreenUpdating, hit <Tab again to fill it in to your code editor window. Type the equal sign and another list with either False or True will display. Check the "Code Window General Use Keys" Help Topic in Visual Basic User Interface Help. At least in Excel 2000 and before, I think Microsoft did not do a very good job of explaining how to really use these features in the editor. Most of us have probably learned it piece-meal the hard way. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 acting out ? | Excel Discussion (Misc queries) | |||
Excel acting up | Excel Discussion (Misc queries) | |||
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 | Excel Programming | |||
combobox change event is running when enable events is false | Excel Programming | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |