I have two workbooks - All the sheets and the workbook have been
protected using Macros in both cases.
When I try to copy a range of cells in a sheet in Workbook1, the ant
lines appear around the selected range indicating activation of the
copy command. However using Ctrl+v or the rightclick, I am unable to
paste to another sheet. The same thing (copy and paste) however works
in case of the Worksheet in the other Workbook. The problem sheet has
some columns hidden and also some cells are open (unlocked) for data
entry. Does this matter?

Please help in trouble-shooting the issue.

Thanks in advance for all the help.

Regards,
Rajendra