Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet......help.
Hi
tzhere's no event to track only format changes. None of these events is triggered by this. The only workaround I can think of is using the OnTime method to periodically check the cell contents 8but this will slow down Excel!) -----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. . |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Excel sheet......help.
Paul,
If by "Format changes" you mean format in the Excel sense (color, font, etc), as opposed to sheet layout, then I'll give you my standard blurb on using formatting as data. Maybe it will be helpful: Using Formatting as data: There's been a lot of the use of formatting, such as color, to store information lately, then doing stuff like sorting based on color. This isn't really the way Excel was designed. Note that by formatting, I mean cell formatting, such as color, font, borders, etc., not sheet layout, as the term formatting is sometimes also used. Formatting is really "output only" -- not intended to be inputted by the user, then tested as data. It's a better idea to put the information (a code or something), for which the formatting was being used, into a cell in some way. Then use that information to cause formatting to change, such as with Conditional Formatting, or a worksheet_Change sub. Now the cell can be easily tested, instead of testing the formatting. Formatting should not be manually applied to a cell to store any kind of information. My 2¢. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |