#1   Report Post  
Old June 11th 08, 03:33 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 788
Default 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   Report Post  
Old June 11th 08, 12:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I NEED HELP QUICK Jennifer Excel Discussion (Misc queries) 6 October 1st 07 04:43 PM
NEED HELP QUICK! excel-chump[_2_] Excel Worksheet Functions 4 September 20th 07 07:10 PM
HELP QUICK I NEED TO KNOW HOW TO ... Kai Jam via OfficeKB.com Excel Discussion (Misc queries) 2 June 8th 05 03:16 AM
NEED HELP QUICK AGAIN! The_ tone Excel Discussion (Misc queries) 0 May 10th 05 07:20 PM
Hi! I need some quick help! Al pal Excel Discussion (Misc queries) 3 February 12th 05 10:37 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017