Excel – allow copy/paste but no data entry

excelvba

I have an Excel sheet which is protected and a few contiguous cells which are editable. Is there a way I can allow a user to copy paste data into these cells, but the user should not be able to type in values directly into these cells? I am willing to accept a solution using VBA too.

Thanks in advance.

Regards,
Anindya

Best Answer

Lock up all the cells so they can neither type nor copy into those cells.

You can ask the user to copy the cells they want.

Put a button on the Excel sheet that says "Paste details". When the click the buttton, use VBA code to paste the details at the specific cell range that you want.

Related Solutions

Excel – Protecting cells in Excel but allow these to be modified by VBA script

Try using

Worksheet.Protect "Password", UserInterfaceOnly := True

If the UserInterfaceOnly parameter is set to true, VBA code can modify protected cells.

Arduino / C: Convert byte array to string or other comparable text format

Here are all functions in string.h for string/memory comparison that you could use with arduino. You could use strcmp or memcmp.

Beware you can't compare in C two strings by simply using == operator. You would just compare values of two memory pointers.

Here is an example of comparison inside your buffer:

if (strcmp((const char*)gsm.comm_buf, "\r\n+CREG: 0,3\r\n\r\nOK\n")==0)
{
    Serial.print("abc");
}

You can use strcmp if your recieved message is null byte terminated, if not you will have to use memcmp for the job.

For both functions You have to check if return value is zero, then those strings are equal.

If you want to compare not from first byte of buffer (with zero index) but for example fifth (index 4) you can just add 4 to your pointer:

if (strcmp((const char*)gsm.comm_buf + 4, "\r\n+CREG: 0,3\r\n\r\nOK\n")==0)

Best Answer

Related Solutions

Excel – Protecting cells in Excel but allow these to be modified by VBA script

Arduino / C: Convert byte array to string or other comparable text format

Related Topic