So, I'm making a template for users to enter data. I find that even though I have protected the sheet if I copy a value from one cell to another, the formatting is also copied into the new cell. How do I prevent this from happening?
Private Sub Workbook_Activate()
Application.CutCopyMode = False
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
*The only mango...the code doesn't work if macros are disabled.