Hi

To synxhronise formatting (p.e. column widths, background/font colors,
fonts, hidding/unhidding rows/columns) for some list of sheets with master
sheet, you can use a procedure or some event (p.e. Workbook Open or Close).

Without VBA, the only way worth of trying, is to design a master sheet at
start, and create all other sheets as copies of this master sheet
(right-click on tab, Move or Copy, check Create a Copy, and OK. And rename
the copyed sheet after that). Of course, when you edit master sheet
afterwards, all sheets copied before keep old design.



--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"killa47" wrote in
message ...

Does anyone know some magic for keeping the same view in multiple sheets
as the active sheet?


--
killa47
------------------------------------------------------------------------
killa47's Profile:
http://www.excelforum.com/member.php...o&userid=28641
View this thread: http://www.excelforum.com/showthread...hreadid=490084