Hi all,
i share my excel workbook on sharepoint for my colleagues to update data in it. But i have this weird problem. I have buttons with assigned macros that shows a filtered version of the whole database. Previously, i selected the 2nd row to the 1000th row and filtered whatever data is in it. And then the problem starts. My data would look like this when pressed a button.
1 Apple
2 Pear
3 Guava
1000
1001
1002
This is just an example of how it is like. Above the data, is a button for colleagues to insert new records. When they press the button, they will be leaded to a 'blank' worksheet starting with number 4. Thus no data inconsistencies. However, some colleagues are lazy and they just insert data at the 1000 mark. So it becomes something like this,
1 Apple
2 Pear
3 Guava
1000 Orange
1001 Honeydew
1002
So.... I need a function that can actually prevent users from entering any data there. They can only enter data after pressing the 'Insert New Record' button. Any ideas?
Thanks
i share my excel workbook on sharepoint for my colleagues to update data in it. But i have this weird problem. I have buttons with assigned macros that shows a filtered version of the whole database. Previously, i selected the 2nd row to the 1000th row and filtered whatever data is in it. And then the problem starts. My data would look like this when pressed a button.
1 Apple
2 Pear
3 Guava
1000
1001
1002
This is just an example of how it is like. Above the data, is a button for colleagues to insert new records. When they press the button, they will be leaded to a 'blank' worksheet starting with number 4. Thus no data inconsistencies. However, some colleagues are lazy and they just insert data at the 1000 mark. So it becomes something like this,
1 Apple
2 Pear
3 Guava
1000 Orange
1001 Honeydew
1002
So.... I need a function that can actually prevent users from entering any data there. They can only enter data after pressing the 'Insert New Record' button. Any ideas?
Thanks
