force entry of rows

apgmin

apgmin

Board Regular
Joined
Mar 1, 2010
Messages
143
Office Version
  1. 2013
Platform
  1. Windows
How do I force the user to complete the first row ( Cell C2 to P2 ) before he can fill cell c3 to P3 or any other cells below this row

Column A,B and H are protected in the sheet they can enter only the other cells
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
I would look at maybe tracking the user to find out who isn't complying (tricky). Its often a training issue anyway
 
Last edited:
Upvote 0
Sorry cant understand your vague response, DO you have any solution to my query in vba
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Force IMAGE To Connect
Replies
3
Views
172
Davey54
D
A
  • Question
Show Data Validation Lists in Next Row of Table
Replies
0
Views
450
AndyPandy27
A
A
  • Question
Insert row takes much time
Replies
4
Views
277
kvsrinivasamurthy
K
C
  • Question
Hiding Sheets during the Before_Close Event
2
Replies
10
Views
314
Jaafar Tribak
Jaafar Tribak
K
  • Question
Drag Equation with blank rows but only increment equation reference by one
Replies
1
Views
106
jkpieterse
jkpieterse

Forum statistics

Threads
1,215,220
Messages
6,123,697
Members
449,117
Latest member
Aaagu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top