| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically run macro on sheet change
Good evening Steven When you say "a change in the sheet" do you mean when the sheet is changed or when the user changes sheets? If the former, which I suspect, try this, inserted in the relevant sheet's code section. Private Sub Worksheet_Change(ByVal Target As Range) ' Your code can go in here End Sub Your macro would then trigger every time that particular sheet is changed. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=380252 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically change time in sheet 2, 3, and 4. | Excel Discussion (Misc queries) | |||
| Sheet tab names change automatically | Excel Discussion (Misc queries) | |||
| How do I automatically change displayed sheet in excel? | Excel Discussion (Misc queries) | |||
| How do I change the Cell color automatically in an Excel sheet wh. | Excel Worksheet Functions | |||
| change one sheet, and automatically the others | Excel Worksheet Functions | |||
![dominicb[_32_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
