ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   font change when editing (https://www.excelbanter.com/excel-discussion-misc-queries/62263-font-change-when-editing.html)

Gary

font change when editing
 
I have this I can place on the sheet module to change font when editing. Is
there a way to put this into a macro so I can enter this into the sheet
automatically each time I am emailed a new version of the workbook?

Thanks.


Private Sub Worksheet_Change(ByVal Target As Range)
Target.Cells.Interior.ColorIndex = 4
End Sub




All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com