 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / August 2007Trigger Event on Format Change
Lots of posters, myself included, would like to trigger an event when a user makes a change in sheet formatting, like changing the interior color of cells. Of course, Excel doesn't consider changing cell formatting a worksheet change. The only thing I can see that changes is the workbook's saved status, and a change in that won't trigger an event. Any suggestions? James Excel before Excel 2007 definitely does not have the ability to trigger and Event on a cell format change. And I wonder what you would do if column B is selected and the entire column is reformatted, which BTW is a lot more efficient than to format the few cells in a column that you actually use. Clear Formats will trigger a change event at least in Excel 2007, but that isn't going to do you much good. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Zone" ... > Lots of posters, myself included, would like to trigger an event when a > user makes a change in sheet formatting, like changing the interior color > of cells. Of course, Excel doesn't consider changing cell formatting a > worksheet change. The only thing I can see that changes is the workbook's > saved status, and a change in that won't trigger an event. Any > suggestions? James David, thanks for your reply. Anyone else have any comments? James > Excel before Excel 2007 definitely does not have the ability to > trigger and Event on a cell format change. [quoted text clipped - 17 lines] >> workbook's saved status, and a change in that won't trigger an event. >> Any suggestions? James Following on with this thread, is there anyway to get the saved status of a workbook into a cell? James > David, thanks for your reply. Anyone else have any comments? James > [quoted text clipped - 19 lines] >>> the workbook's saved status, and a change in that won't trigger an >>> event. Any suggestions? James What do you mean by status. If you mean if the workbook has been changed then as soon as you put "Saved" into a cell, the workbook will be in a changed status. -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm > Following on with this thread, is there anyway to get the saved status of > a workbook into a cell? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.