I never realized the F4 trick. However, I must also agree with Dave,
there is no way of being able to change this pattern without having to
deal with macros. Even when dealing with macros, there is no real way
of having those codes triggered without having to use the
WorksheetChange Event on either every single worksheet of every
workbook that you touch or on every ThisWorkbook module of every
workbook that you touch. If you were to use this method, it could
create problems for others that may be modifying thus you must also
provide for some sort of trapping mechanism in order to prevent hassles
for other users.

Sincerely,

Ronald R. Dodge, Jr.



--
Dodgester
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2422520.html