Disabling Paste Options
 

Hi All,

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?

Disabling Paste Options
 

This code may help:-


http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike


"ewan7279" wrote:

Hi All,

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?

Disabling Paste Options
 

Thanks Mike, that's great!!

"Mike H" wrote:

This code may help:-


http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike


"ewan7279" wrote:

Hi All,

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?

Disabling Paste Options
 

Hi Mike,

I am now getting a strange error message when I try and right click paste in
any other workbook. I've no idea how or why this is happening, but the
message says:

"'somefile.xls' could not be found. Check the spelling of the file name,
and verify that the location is correct. If you are trying to open the file
from your list of most recently used files on the file menu, make sure that
the file has not been renamed, moved or deleted."

The file it mentions does not exist. Could the code included in your post
have anything to do with this? I don't see how but there's no other logical
explanation...

Thanks,
Ewan.

"ewan7279" wrote:

Thanks Mike, that's great!!

"Mike H" wrote:

This code may help:-


http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike


"ewan7279" wrote:

Hi All,

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?

Disabling Paste Options
 

For info:

I found the below website and used 'Application.CommandBars("Cell").Reset'
in the immediate window to restore my right - click menu. The problem with
right-click paste has now gone (paste special option has also been restored
on my right click menu - didn't realise it had disappeared!!)

http://www.mvps.org/dmcritchie/excel/rightclick.htm


"ewan7279" wrote:

Hi Mike,

I am now getting a strange error message when I try and right click paste in
any other workbook. I've no idea how or why this is happening, but the
message says:

"'somefile.xls' could not be found. Check the spelling of the file name,
and verify that the location is correct. If you are trying to open the file
from your list of most recently used files on the file menu, make sure that
the file has not been renamed, moved or deleted."

The file it mentions does not exist. Could the code included in your post
have anything to do with this? I don't see how but there's no other logical
explanation...

Thanks,
Ewan.

"ewan7279" wrote:

Thanks Mike, that's great!!

"Mike H" wrote:

This code may help:-


http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike


"ewan7279" wrote:

Hi All,

Is there a a way to disable the usage of, or change the function of,
right-click Paste, Edit=Paste and the Menu Bar Paste button to restrict
users to only be able to enter values and/or paste values into a sheet to
avoid changing existing formatting?