Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default disappearing worksheet_change VBA code - help!

I created worksheet level code triggered by the worksheet_change event.
The code works fine, but I can't see it when I click on the sheet
object anymore.

Even stranger, if I create new code in the sheet like this:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "boo!"
End Sub


Then I get the behavior from my missing worksheet_change code, *plus* I
get the "boo!" message. So the "missing" code is clearly still being
executed. (The code's not anything complicated--it just looks for a
change in a particular cell, then changes the color of some text in a
range.)

I've replicated this on two machines, one with Excel 2000 and one with
Excel 2003.

Things I've tried:

- running the code cleaner utility at
http://www.appspro.com/utilities/Cleaner.asp
- looking to see if accidentally put the code at the workbook level (I
didn't)

I'm totally at my wits' end. Any ideas?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default disappearing worksheet_change VBA code - help!

Um ... never mind ... I forgot that I originally decided against using
the worksheet_change event, and instead used a conditional formatting
trick to accomplish what I wanted. So there never was any
worksheet_change code. Oops.

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
how do i keep zip code zeros from disappearing debh Excel Discussion (Misc queries) 2 May 30th 07 06:40 PM
need help creating a Worksheet_Change code Cajun20th Excel Worksheet Functions 4 May 18th 06 09:12 AM
Worksheet_Change even code will not run retseort[_13_] Excel Programming 3 November 28th 05 10:35 PM
Code WAY too slow... (worksheet_change event) [email protected] Excel Programming 0 January 11th 05 08:34 PM
vba code disappearing No Name Excel Programming 1 May 17th 04 11:20 AM


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

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"