View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel sheet......help.

Format changes don't trigger an event.

For the user editing a cell, you can also use the change event.

--
Regards,
Tom Ogilvy

"Paul Hilton" wrote in message
...
I am developing an app using Excel objects.
I need to track the changes made in the cells while a user is working on

an
excel sheet.
The only method I know is to use ActiveSheet and SelectionChanges and
compare the sheet before and after user makes changes. Are there any other
bets I have? Maybe some other events, methods, to track format changes in
cells of a sheet ?
Awaiting response.........Thanks.