Re: Restricting Paste in Excel

From: halimnurikhwan@xxxxxxxxx
Date: 29 Aug 2006 22:08:44 -0700

Hi FSC,

I've tried this :
Sub diab()
Application.OnKey "^{v}", ""
Application.CommandBars.FindControl(ID:=22).Enabled = False
End Sub

Rgds,

Halim

FCS menuliskan:

How can I restrict the "Paste" functionality in Excel to prevent the user
from pasting cell formats when copying and pasting? (i.e. only allowing
pasting values and/or formulas)

I am using Excel 2003

Prev by Date: Re: Tom Ogilvy - Need a little change
Next by Date: Re: Copy from Excel and paste as bitmap in Word
Previous by thread: Re: Restricting Paste in Excel
Next by thread: Re: Hiding rows w/ "" cell and printing
Index(es):
- Date
- Thread

Relevant Pages

Re: Why wont this work!
... That routine doesn't actually do the pasting--it just reacts to your pasting. ... Private Sub Worksheet_Change ... Dim myRng As Range ... On Error GoTo 0 ...
(microsoft.public.excel.misc)
Re: Popup Menu problem while copy and paste..
... I am copying & pasting the data in text widget. ... After pasting data using popup menu, ... sub paste_data ...
(comp.lang.perl.tk)
RE: CommandBars(33)
... >> range of cells with the right mouse button and releasing the button. ... >> Sub CreateButton() ... copy and pasting manually works perfect. ... or range border method. ...
(microsoft.public.excel.programming)
Popup Menu problem while copy and paste..
... I am copying & pasting the data in text widget. ... After pasting data using popup menu, ... sub paste_data ...
(comp.lang.perl.tk)
Re: Pasting in a range
... The sub is pasting in the correct range but not the correct data. ... Also, it pastes very slow. ... The sub is pasting the value in the cell rather than the ...
(microsoft.public.excel.programming)