Excel 97 Mouse scroll-wheel stops working after run macro- edited


D

dk_

Re-posted to add...

Problem in Excel 97 (seems to work in 2007). See below:

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