Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding macro
Hello
I wrote a code that copys values from one workbook to another workbook. The problem is that when goes from one workbook to another there is a flickering in the screen. Eventhough i wrote application.screenupdating still showing macros executions Can you tell me how to hide macro execution?Thanks in advance Thanks AngelikiS application.screenupdating= False Windows("Book1").Activate Sheets("Information").Select Range("A1:I12").Select Selection.Copy Windows("Book2").Activate Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Columns("A:I").Select Columns("A:I").EntireColumn.AutoFit Range("A1").Select Sheets("Sheet1").Select Sheets("Sheet1").Name = "Information" Windows("Book1").Activate Application.CutCopyMode = False Range("A1").Select application.screenupdating= True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for hiding rows | New Users to Excel | |||
help... i might need a macro for this.. (hiding a specific # of ro | New Users to Excel | |||
Macro for hiding and printing. | Excel Discussion (Misc queries) | |||
Macro for hiding rows | Excel Discussion (Misc queries) | |||
Macro for hiding rows | Excel Discussion (Misc queries) |