Template Creation

Occasional Visitor

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?

1 Reply
best response confirmed by patsoks (Occasional Visitor)


maybe with VBA code.


Option Explicit
Private Sub Workbook_Activate()
    Application.CutCopyMode = False
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
End Sub


*The only mango...the code doesn't work if macros are disabled.


Additional infos:

Protection.AllowFormattingCells property (Excel)

How to protect cell formatting but only allow data entry in Excel?


Hope I was able to help you with this information.



I know I don't know anything (Socrates)