ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mouse scroll-wheel stops working after run macro (https://www.excelbanter.com/excel-programming/443604-mouse-scroll-wheel-stops-working-after-run-macro.html)

dk_

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 ] ---------------------------------




All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com