On Excel worksheet, manually I select some Rows, not range, but rows
Need VBA to copy these rows to next blank Row of second workbook, then save second workbook as Read Only
Worksheet in that second workbook is: Sheet1(ALL)
If that second workbook needs to be opened for that, then need code to open it and after copying data into it save as Read Only and leave opened for my view
Where is the second workbook? If it needs opening the code will need to know it's location.
Let's call it C\Desktop\