Mar 15 2022 07:46 AM
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?
Mar 15 2022 11:31 AM
Solutionmaybe 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)
Mar 15 2022 11:31 AM
Solutionmaybe 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)