Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Excel defaults
Hi Folks,
Is there a way to change the default style of a cell comment, for example to 10 point text, not bold? Is there a way to set the default alignment of all cells in a new sheet centered horizontally and vertically? Thanks! Tom Kreutz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Excel defaults
"Tom Kreutz" wrote in message ... Hi Folks, Is there a way to change the default style of a cell comment, for example to 10 point text, not bold? Is there a way to set the default alignment of all cells in a new sheet centered horizontally and vertically? Thanks! Tom Kreutz Yes to the second question, not sure about the first. Create a new sheet built the way you want it. Then, click Help (on the menu), and look for info on creating templates. Done correctly, you'll be able to click File, New, and see your template there along with all the others (if any yet). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Excel defaults
Here are the answers to my own questions, found via Google Groups.
Sorry to have asked before looking myself. From Bernie Deitrick, Oct 26 1999, in microsoft.public.excel.programming Sub New_Comment() ' Inserts a comment in 10 point regular text. On Error Resume Next With ActiveCell.AddComment.Shape.TextFrame.Characters.F ont .Size = 10 End With SendKeys "+{F2}" End Sub From Gord Dibben, Aug 21 2003 in microsoft.public.excel.misc You can go to FileNew and set up a worksheet as you wish. Delete other sheets in this workbook. FileSave AsTypeTemplate(*.xlt) Name it SHEET and save it to your XLSTART folder. Any new worksheets added or inserted will have the attributes you want. Also save it as BOOK.XLT to have it as the default workbook that opens when you want a new workbook. Tom Kreutz wrote: Is there a way to change the default style of a cell comment, for example to 10 point text, not bold? Is there a way to set the default alignment of all cells in a new sheet centered horizontally and vertically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Prevent excel changing numbers data to dates. | Excel Discussion (Misc queries) | |||
Excel Changing Numbers Automatically | Excel Discussion (Misc queries) | |||
Open Excel in a browser without changing URL | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |