Only allowing to fill a cell by the command button

Objective question this time.

There is a way to lock an entire column, for instance, that only allows the user to fill the cells from that column clicking on a sheet command button (fetching data from some place), not allowing the person to type or edit directly ?
I tried by the worsksheet change event, but it fires regardless of I fill the cells by the command button or typing values directly


Sorry my bad english

Hi, what I would suggest is that all actions directly to the worksheet be cancelled, but that you place a button somewhere on the worksheet that only unlocks the selected cell when you press that button, if there are special conditions or restrictions fpr that cell I would even go a little further and use a small userform for only one cell entry.
You know there is an international section wher you can post your question in your own language.
D'esta maneira podes receber respostas na tua lingua.

I'm missing a library, what's that supposed to be?

If you do not intend to share this file that's okay but keep in mind that addding non-commonly used libraries in workbooks you want to share with others will only give problems and errors

Yes, but it keeps blocking because of the missing library, I'll see if I can remove everything that references to that

No, it's too built in in you modules.
Sorry, no go on my side

Originally Posted by ByteMarks

You could try:
Declare a public variable blnButton as Boolean

The in the click event of the Button

Please Login or Register  to view this content.

In the ChangeEvent of the sheet

Please Login or Register  to view this content.

Man, it worked!



My idea was to create a static variable to count the number of times the click button was pressed. But it would be a potential mess

Thanks a lot!