LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Workbook code vs worksheet code

Hi-This code works when in This Workbook section for code but I want
to have it work in one worksheet only. I tried just copying the code
the the specifc worksheet. Didn't work. What do I change?

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
Target.Interior.Color = vbRed
End Sub

 
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
Problem w/code to copy worksheet to new workbook ploddinggaltn Excel Programming 9 October 29th 06 10:00 PM
run code on opening workbook and apply code to certain sheets Jane Excel Programming 7 August 8th 05 09:15 AM
Inserting a worksheet into an open workbook via VBA code manillla Excel Programming 2 June 14th 05 01:30 AM
specifying workbook for worksheet code name Doug Glancy Excel Programming 7 January 25th 04 12:00 AM
Copy worksheet, code and all, into workbook? Ed[_9_] Excel Programming 2 September 22nd 03 03:11 PM


All times are GMT +1. The time now is 02:13 AM.

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"