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 |
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 |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com