Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ] --------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mouse scroll-wheel stops working after run macro | Excel Programming | |||
Scroll mouse wheel not working in Excel 2007 | Excel Discussion (Misc queries) | |||
Can't Scroll w/ Mouse Wheel in Excel | Excel Discussion (Misc queries) | |||
How do I get the scroll wheel on mouse to work in Excel | Excel Discussion (Misc queries) | |||
How do I use the mouse wheel to scroll horizontally in excel? | Excel Discussion (Misc queries) |