Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't change font Terri Excel Worksheet Functions 2 December 19th 05 08:15 PM
How do I change the font color based on results of an IF stateme MKLeisure Excel Worksheet Functions 2 December 16th 05 03:53 PM
Can't change cell value with unusual font. Terri Excel Worksheet Functions 4 December 13th 05 09:41 PM
change font color of first cell in data table attached to chart momo Charts and Charting in Excel 2 February 18th 05 01:47 AM
Change datalabel font size for all chartobjects in a row Marie J-son Charts and Charting in Excel 2 December 5th 04 07:02 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"