events=false not acting?


G

Guest

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
 
Ad

Advertisements

B

Bill Renaud

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top