Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
dk_ dk_ is offline
external usenet poster
 
Posts: 70
Default 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
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
Scroll mouse wheel not working in Excel 2007 KrisR Excel Discussion (Misc queries) 0 July 29th 09 04:48 PM
When editing a funciton wheel mouse stops Nic Bowker Excel Discussion (Misc queries) 2 November 9th 07 08:49 PM
mouse scroll wheel rat Excel Discussion (Misc queries) 3 July 11th 07 10:52 PM
Wheel on mouse doesn't scroll in VB Nolan Excel Programming 6 July 12th 06 01:29 PM
scroll with wheel mouse Scott Excel Programming 1 August 11th 05 08:22 PM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Excel"