Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Worksheet Change Event Does Not Work When Reopening Excel

I copied an example from Chip Pearson's web site for time quick
entry. I modified it to fit my needs (expanded the target range only)
and it worked fine. The problem I am having is that when I reopened
Excel the next day it did not work. I have since found out that I can
open and close the workbook and as long as I do not close Excel it
will work. If I close Excel and reopen it then I have to recopy the
example from Chip Pearson to make it work.

I know I am missing something here but I do not know what. Any help
is appreciated.

Thanks
Dennis
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
change event doesnt work Jonathan Excel Programming 0 July 31st 07 11:18 AM
Excel Worksheet Change Event susiecmore Excel Programming 4 April 27th 06 08:30 AM
Change event fails to work Mark F Excel Worksheet Functions 3 November 10th 05 12:08 PM
worksheet change event doesn't work gig Excel Programming 3 March 20th 05 02:18 PM


All times are GMT +1. The time now is 12:54 PM.

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"