Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
just a quick one
Ok guys..and gals...is it possible when inserting a row..to have it default
to format same as below..instead of allowing an option of below or above...my above row is loocked..and when the user inserts a row..i want it automatically formatted same as below...the unlocked row..so that they can access this new row. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
just a quick one
Maybe you could use a macro.
It would unprotect the worksheet (is that required?), then copy|insert the following row, remove formulas/constants???, but keep the formatting???), then reprotect the worksheet. If you want to try, you could record a macro when you do it manually. Then tweak that macro. David McRitchie has a version that you may want to review: http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas It uses the row above, but may give you some ideas. chris wrote: Ok guys..and gals...is it possible when inserting a row..to have it default to format same as below..instead of allowing an option of below or above...my above row is loocked..and when the user inserts a row..i want it automatically formatted same as below...the unlocked row..so that they can access this new row. thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP QUICK | Excel Discussion (Misc queries) | |||
NEED HELP QUICK! | Excel Worksheet Functions | |||
HELP QUICK I NEED TO KNOW HOW TO ... | Excel Discussion (Misc queries) | |||
NEED HELP QUICK AGAIN! | Excel Discussion (Misc queries) | |||
Hi! I need some quick help! | Excel Discussion (Misc queries) |