Thread: Function doesn't work correctly with protection on
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
tkstock[_10_] tkstock[_10_] is offline
external usenet poster
  
Posts: 1
Default Function doesn't work correctly with protection on

I am using the following code, and it works fine for me with the shee
protected:


Code
-------------------
Private Sub Worksheet_Change(ByVal Target As Range)
Target.NoteText InputBox("Enter comment:")
End Su
-------------------


NoteText is old, but it's easy.

HT

--
tkstoc

-----------------------------------------------------------------------
tkstock's Profile: http://www.excelforum.com/member.php...fo&userid=1444
View this thread: http://www.excelforum.com/showthread.php?threadid=37910

Reply With QuoteReply With Quote