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?

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?

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?

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?

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?