I have a worksheet where I protect the data from users. I wrote a macro to
unprotect the sheet then copy a selection and then protect the sheet again.
The problem is once the macro protects the sheet it loses the data that was
copied and the highligted copy section disapears. Is there a special way to
copy the data so that it is not lost when I protect the worksheet? Is there a
better way to do this?

Also, I have created several buttons on the worksheet which perform various
macros. Is there any way to put the buttons onto the ribbon or anywhere else
in the workbork besides the sheet itself?