Thread: How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amolin[_2_] Amolin[_2_] is offline
external usenet poster
  
Posts: 1
Default How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ?

How to use VBA to copy this code from one opened workbook to all opened
workbooks ? I need this code under "Thisworkbook" object of each opened
workbook. Thank you!


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
Target As Range)
Application.SendKeys "{F9}"
End Sub


--
Amolin
------------------------------------------------------------------------
Amolin's Profile: http://www.excelforum.com/member.php...fo&userid=8321
View this thread: http://www.excelforum.com/showthread...hreadid=375868

Reply With QuoteReply With Quote