P
pkeegs
Users of my worksheet (Excel 2003) occasionally manually copy data from one
sheet into a sheet with conditional formatting. It requires them to
'paste>values'. Some users forget and simply 'paste' the data which deletes
the conditional formatting. Is there any way that I can protect the formats
so that if they 'paste', a dialogue box will indicate that they need to
'paste>values'?
sheet into a sheet with conditional formatting. It requires them to
'paste>values'. Some users forget and simply 'paste' the data which deletes
the conditional formatting. Is there any way that I can protect the formats
so that if they 'paste', a dialogue box will indicate that they need to
'paste>values'?