Excel sheet ...... help.
 

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.

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.

Excel sheet ...... help.
 

Hi
see your other post

-----Original 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.



.