COPY & PASTE problem

[strokebow]

Hi,

Within Excel I am unable to copy and paste conventionally. ie) by right clicking and selecting copy. It is blanked out. However, I can copy by using the keyboard shortcut.

can anyone shed somelight on to this situation please?

thanks!!!

[ibexcel]

Hi,

Within Excel I am unable to copy and paste conventionally. ie) by right clicking and selecting copy. It is blanked out. However, I can copy by using the keyboard shortcut.

can anyone shed somelight on to this situation please?

thanks!!!

Hi,
The copy/paste option during right-click would've been disabled using VBA program. If you know VBA, open the program and you will find the related line where you can re-enable it.

[strokebow]

thanks for your reply.

Could you please talk me through the process

thanks again

[strokebow]

Please guide me through how to enable my co[py and paste

Thanks

[ibexcel]

- On the top left corner of your workbook, next to the File menu, you will the excel X symbol.

- right click on that and select view code

- it will pop-up a screen what we call vba editor

- there will find a line which looks like:
Application.CommandBars("cell").Controls("copy").Enabled = False

- change the false value in the end to "true", this will re-enable copy option

- there must be a similar line for paste, change that too to true

[strokebow]

I was unable to locate these copy and paste 'functions'.

I am using excel 2003

anyone have any ideas?

Thanks

[twofootgiant]

you were unable to get into the vb editor....or you couldnt find the line once you were in there?

[strokebow]

I was unable to locate the spcific line