Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

RESTRICT PASTING FORMATS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FARAZ QURESHI - 26 Mar 2008 12:56 GMT
What code may be applied with respect to only ONE sheet, upon which if any
data is pasted (either by Ctrl+V or Enter) only the values are pasted so as
to preserve the format and application of Conditional Formatting?

Signature


Best Regards,
FARAZ A. QURESHI

Jim Rech - 26 Mar 2008 13:26 GMT
I don't know what you mean by 'code'.  There is no cell format that
restricts a cell to being the recipient of pasted values only.

For a macro you might see if this holds water.  Copy it into the sheet's
module (right click sheet tab and pick View Code):

Private Sub Worksheet_Change(ByVal Target As Range)
   Dim Temp As Variant
   Temp = Target.Formula
   With Application
       .EnableEvents = False
       .Undo
       Target.Formula = Temp
       .EnableEvents = True
   End With
End Sub

Signature

Jim

| What code may be applied with respect to only ONE sheet, upon which if any
| data is pasted (either by Ctrl+V or Enter) only the values are pasted so as
| to preserve the format and application of Conditional Formatting?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.