I have recorded a macro and i wish to keep the keyboard shortcut as ctrl C. I
have recorded keeping the short key as ctrl Q. Kindly help how can i change
it?

Second thing once i click record macro excel is not asking for relative
reference option. Kindly help how can i get that as well.

Thanks
Boss