Protect cells after adding to list

[scottylad2]

Hi Excelers,

I have a DVD data base which i want to add all my DVD's to. What i want though is once i put the dvds into the list and i move onto the next row i want the row i've just added info onto to become protected. My list as is has just been made into a bog standard table with no rangees named or anything.

I have a macro and advanced filter running so i can create a new list using advanced filtering and the code for that is
Sub FilmFinder()
'
' FilmFinder Macro
'

'
Columns("A:E").Select
Columns("A:E").EntireColumn.AutoFit
Columns("G:K").Select
Columns("G:K").EntireColumn.AutoFit
Range("M16").Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Range("A4:E2001").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range _
("A1:E2"), CopyToRange:=Range("G4:K4"), Unique:=False
ActiveWindow.SmallScroll Down:=-18
Columns("G:K").Select
Columns("G:K").EntireColumn.AutoFit
Range("F3").Select
End Sub

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	TITLE	STARRING	CO-STARRING	GENRE	RATING
2
3	Look for your film by entering in the boxes above part of the title orArtist or co-star or just look for a film by clicking on the Genre or age rating then click the find film button
4	TITLE	STARRING	CO-STARRING	GENRE	RATING		TITLE	STARRING	CO-STARRING	GENRE	RATING
5	28 Days	Sandra Bullock	Viggo Morgensten	Romance	15		28 Days	Sandra Bullock	Viggo Morgensten	Romance	15
6	Billy Elliot	Julie Walters	Gary Lewis	comedy	15
7	Bridget Jones	Renee Zellwegner	Hugh Grant	Romance	15
8	Bridget Jones Diary	Renee Zellwegner	Hugh Grant	Romance	15
9	Brokeback Mountain	Heath Ledger	Jake Gyllenhaal	Romance	15
10	Bruce almighty	Jim carey	Morgan Freeman	comedy	12
11	Dreamcatcher	Morgan Freeman	Donnie Whalberg	Horror	15
12	Failure to Launch	Mathew McConaughey	Jessica Parker	comedy	12
13	Fallen	Denzel Washington	John Goodman	Chiller	15
14	Harry Potter and the Chambers of secrets	Daniel Radcliffe	Robbie Coltrane	Adventure	PG
15	Harry Potter goblet of fire	Daniel Radcliffe	Robbie Coltrane	Adventure	12
16	Harry Potter prisoner of Azkaban	Daniel Radcliffe	Robbie Coltrane	Adventure	PG
17	High Crimes	Ashley Judd	Morgan Freeman	Thriller	12
18	Hot Fuzz	Simon Pecc	Nick Frost	comedy	15
19	Ice age 2	cartoon characters	Animated	Cartoon	U
20	Identity	John Cusack	Ray Liotta	Horror	15
Film Finder

Hope you get the drift from this

many thanks

 

[scottylad2]

Film Finder

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 151px;"><col style="width: 131px;"><col style="width: 73px;"><col style="width: 71px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td></tr><tr style="height: 23px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td><td style="border: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">CO-STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">GENRE</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">RATING</td></tr><tr style="height: 34px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); color: rgb(102, 102, 153); font-weight: bold; font-size: 18pt;"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); color: rgb(102, 102, 153); font-weight: bold; font-size: 18pt;"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); color: rgb(102, 102, 153); font-weight: bold; font-size: 18pt;"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); color: rgb(102, 102, 153); font-weight: bold; font-size: 18pt;"> </td></tr></tbody></table>

Film Finder

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 151px;"><col style="width: 131px;"><col style="width: 73px;"><col style="width: 71px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>B</td><td>C</td><td>D</td><td>E</td></tr><tr style="height: 23px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="border: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">CO-STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">GENRE</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">RATING</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Sandra Bullock</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Viggo Morgensten</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Romance</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Julie Walters</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Gary Lewis</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">comedy</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Renee Zellwegner</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Hugh Grant</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Romance</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Renee Zellwegner</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Hugh Grant</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Romance</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Heath Ledger</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Jake Gyllenhaal</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Romance</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Jim carey</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Morgan Freeman</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">comedy</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">12</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">11</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Morgan Freeman</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Donnie Whalberg</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Horror</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">12</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Mathew McConaughey</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Jessica Parker</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">comedy</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">12</td></tr></tbody></table>

Film Finder

<table style="font-family: Calibri,Arial; font-size: 11pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 53px;"><col style="width: 98px;"><col style="width: 122px;"><col style="width: 64px;"><col style="width: 71px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>G</td><td>H</td><td>I</td><td>J</td><td>K</td></tr><tr style="height: 23px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="border: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">TITLE</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">CO-STARRING</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">GENRE</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(51, 204, 204); color: rgb(255, 255, 255); font-weight: bold; font-size: 14pt; text-align: center;">RATING</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">28 Days</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Sandra Bullock</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Viggo Morgensten</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">Romance</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); text-align: center;">15</td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td></tr><tr style="height: 18px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0);"> </td></tr></tbody></table>
The top table is where the search query would go
the middle table is where the DVD's are all listed and the bottom on is where the result will display.

I have a form button linked to the macro from the earlier post, as i said in the first post it's after i type in the DVDs information i'd like to start a new row, either by clicking a return button or something and move down and to the left most cell but also protect the row i've just left. Is this possible?

Excel tables to the web >> Excel Jeanie HTML 4

 

[scottylad2]

Bump