| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy layout to all worksheets
Hi
I have a workbook with 25 worksheets. The first sheet is my "template "; all other are based upon this template The question is: Whe I chnage something on the template: layout/colour of a cell, columwith, validation of a range of cells.... I want it to be changed in all sheets. How can this be done? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy layout to all worksheets
This should copy formats, but not sure what you mean by "validation of a
range of cells". Change "Sheet1" to your template name. Sub Test() Dim wsTpl As Worksheet, ws As Worksheet, r As Range Set wsTpl = Worksheets("Sheet1") 'template Application.ScreenUpdating = False wsTpl.Cells.Copy For Each ws In ActiveWorkbook.Worksheets If Not ws Is wsTpl Then ws.Activate 'only to enable r.Select later Set r = ActiveCell ws.Cells.PasteSpecial Paste:=xlFormats r.Select 'to deselect whole sheet End If Next wsTpl.Activate Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Regards, Peter "Jean-Paul De Winter" wrote in message ... Hi I have a workbook with 25 worksheets. The first sheet is my "template "; all other are based upon this template The question is: Whe I chnage something on the template: layout/colour of a cell, columwith, validation of a range of cells.... I want it to be changed in all sheets. How can this be done? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy layout to all worksheets
If you select all sheets (group the sheets) and make the change.
Make sure you ungroup before making changes not intended for all sheets. -- Regards, Tom Ogilvy "Jean-Paul De Winter" wrote in message ... Hi I have a workbook with 25 worksheets. The first sheet is my "template "; all other are based upon this template The question is: Whe I chnage something on the template: layout/colour of a cell, columwith, validation of a range of cells.... I want it to be changed in all sheets. How can this be done? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy layout to all worksheets
great help.... saves hours of time
Thanks "Tom Ogilvy" schreef in bericht ... If you select all sheets (group the sheets) and make the change. Make sure you ungroup before making changes not intended for all sheets. -- Regards, Tom Ogilvy "Jean-Paul De Winter" wrote in message ... Hi I have a workbook with 25 worksheets. The first sheet is my "template "; all other are based upon this template The question is: Whe I chnage something on the template: layout/colour of a cell, columwith, validation of a range of cells.... I want it to be changed in all sheets. How can this be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I switch from Office 2007 layout to the old 2003 layout? | Excel Discussion (Misc queries) | |||
| Copy page layout and margin from sheet to sheet | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| How do I get/copy the (same) layout from a linked worksheet? | Excel Worksheet Functions | |||
| I want to copy only the layout and formulas and not the exisiting | Excel Discussion (Misc queries) | |||
Linear Mode
