Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Dukker Jansen   on Sep 02 In MS Office Category.

  
Question Answered By: Fadiyah Khan   on Sep 02

I understood you and was also hoping for an answer. I was able to
eliminate (not trap) the "cold" pop-up in my application by setting the
Cancel boolean as below. Obviously this only works on Double click but
it's a help and you probably want to use Target to control the
canceling.



Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
Target As Range, Cancel As Boolean)
Cancel = True

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on the protected sheet error message Or get search suggestion and latest updates.


Tagged: