Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
resetting worksheet properties
I have a macro which contains commands that alter a worksheet's appearance
(row height, column width, borders, color, etc.). Is there a function I can use in a macro that will reset all of these properties (to the default worksheet properties used on a blank worksheet) or do I have to each separately. TIA Mike -- Michael J. Malinsky |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
resetting worksheet properties
how about
Worksheets("Blank").cells.copy Activesheet.Cells.PasteSpecial xlFormats given you have a sheet named blank that has the default formats. This won't fix column widths or row heights or unmerge cells, but: Cells.Style="Normal" Regards, Tom Ogilvy "Michael J. Malinsky" wrote in message ... I have a macro which contains commands that alter a worksheet's appearance (row height, column width, borders, color, etc.). Is there a function I can use in a macro that will reset all of these properties (to the default worksheet properties used on a blank worksheet) or do I have to each separately. TIA Mike -- Michael J. Malinsky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart worksheet names keep resetting | Charts and Charting in Excel | |||
Properties on Excel Worksheet and definitions | Excel Discussion (Misc queries) | |||
Worksheet Properties - Last User | New Users to Excel | |||
Use of file properties in fields in worksheet | Excel Discussion (Misc queries) | |||
Resetting the end of a worksheet | New Users to Excel |