LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default Excel 97 Mouse scroll-wheel stops working after run macro- edited

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mouse scroll-wheel stops working after run macro dk_ Excel Programming 0 September 14th 10 08:42 AM
Scroll mouse wheel not working in Excel 2007 KrisR Excel Discussion (Misc queries) 0 July 29th 09 04:48 PM
Can't Scroll w/ Mouse Wheel in Excel SJK Excel Discussion (Misc queries) 0 April 7th 09 05:17 AM
How do I get the scroll wheel on mouse to work in Excel Rhyu Excel Discussion (Misc queries) 1 September 4th 08 12:56 PM
How do I use the mouse wheel to scroll horizontally in excel? Alison Excel Discussion (Misc queries) 4 August 17th 05 10:58 AM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"