Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
Unwanted format changes within spread sheet
Spreadsheet set up for top alignment and font Times New Roman when editing or in new cell changes to bottom alignment and different font and font size. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
To fix this kind of behavior, include the following worksheet event macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.VerticalAlignment = xlTop Cells.Font.Name = "Times New Roman" End Sub Because it is worksheet code, it is very easy to install and use: 1. right-click the tab name near the bottom of the window 2. select View Code - this brings up a VBE window 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To remove the macro: 1. bring up the VBE windows as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm To learn more about Event Macros (worksheet code), see: http://www.mvps.org/dmcritchie/excel/event.htm -- Gary''s Student - gsnu200800 "Charlene" wrote: Unwanted format changes within spread sheet Spreadsheet set up for top alignment and font Times New Roman when editing or in new cell changes to bottom alignment and different font and font size. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |