| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining End User Actions
I have a worksheet that calls a procedure to format every other row wit gray for readability. However if an end user sorts the worksheet tha formatting gets all screwed up. Is there any way to determine an en user's actions on a worksheet such as performing a sort? I thought maybe a work around would be the SheetChange or the Chang Event to look for a change to the worksheet and then call the forma row procedure again. This doesn't seem like the best solution. Can anyone suggest a bette way -- rayd ----------------------------------------------------------------------- rayd8's Profile: http://www.excelforum.com/member.php...fo&userid=2626 View this thread: http://www.excelforum.com/showthread.php?threadid=39917 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want user to input informartion to control mnacro actions | Excel Discussion (Misc queries) | |||
| User initiated break/actions during macro execution | Excel Programming | |||
| determining coordinates for screen placement of user form | Excel Programming | |||
| Determining Last User Action | Excel Programming | |||
| Determining end of user-selected range | Excel Programming | |||
![rayd8[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
