Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mouse scroll-wheel stops working after run macro
Help please...
After running the macro below, the mouse scroll-wheel stops working. If I do: 'file'--'open'--'cancel', then the mouse scroll-wheel works again. Appreciate some help here. Thanks. -dk -------------- [ begin marco ] -------------------------- Sub QuoteCopy_ActiveSheet_to() ' copy quote data from a_TEST.xls Dim DKWkbk As Workbook Dim ActSheet As Worksheet Dim myDir As String Application.ScreenUpdating = False Set ActSheet = ActiveSheet myDir = ActiveWorkbook.Path Set DKWkbk = Workbooks.Open _ (FileName:=myDir & Application.PathSeparator & "a_TEST.xls") DKWkbk.Worksheets(1).Range("quotearea").Copy _ Destination:=ActSheet.Range("QuoteDate") Application.CutCopyMode = False DKWkbk.Close savechanges:=False ActSheet.Select ActSheet.Range("QuoteDate").Select Application.ScreenUpdating = True End Sub ----------------- [ end macro ] --------------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll mouse wheel not working in Excel 2007 | Excel Discussion (Misc queries) | |||
When editing a funciton wheel mouse stops | Excel Discussion (Misc queries) | |||
mouse scroll wheel | Excel Discussion (Misc queries) | |||
Wheel on mouse doesn't scroll in VB | Excel Programming | |||
scroll with wheel mouse | Excel Programming |