Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cut, Copy, Paste, PasteSpecial grayed out.

Puzzling problem: In Excel both under "Edit" and in the shortcut menu "Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Cut, Copy, Paste, PasteSpecial grayed out.

I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu "Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cut, Copy, Paste, PasteSpecial grayed out.

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Cut, Copy, Paste, PasteSpecial grayed out.

Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you mean them
all???????)

If you're only concerned with the rightclick that shows up when you're in a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cut, Copy, Paste, PasteSpecial grayed out.

Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike


"Dave Peterson" wrote in message
...
Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you mean
them
all???????)

If you're only concerned with the rightclick that shows up when you're in
a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that
on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and
re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.

--

Dave Peterson


--

Dave Peterson





  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Cut, Copy, Paste, PasteSpecial grayed out.

Try it again.

If it doesn't work, share what rightclick menu you're trying to reset.

===
You can reset all the toolbars if you want.

(Saved from a previous post)

The first thing I would do is reset my toolbar by deleting the associated
toolbar file (*.xlb).

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

And delete/move them.

Then reopen excel and do some minor modifications. Then close and reopen excel
to see if it worked.

If it worked, make your real changes.

If it didn't work, put your *.xlb file back (if you want).

"news.microsoft.com" wrote:

Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike

"Dave Peterson" wrote in message
...
Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you mean
them
all???????)

If you're only concerned with the rightclick that shows up when you're in
a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that
on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and
re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Cut, Copy, Paste, PasteSpecial grayed out.

Dave, this worked!
Deleting the .xlb file and having Excel replace it reset my right-click
shortcut menu.
Thanks for all your help!
Mike

"Dave Peterson" wrote in message
...
Try it again.

If it doesn't work, share what rightclick menu you're trying to reset.

===
You can reset all the toolbars if you want.

(Saved from a previous post)

The first thing I would do is reset my toolbar by deleting the associated
toolbar file (*.xlb).

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're
worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you
could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed
on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

And delete/move them.

Then reopen excel and do some minor modifications. Then close and reopen
excel
to see if it worked.

If it worked, make your real changes.

If it didn't work, put your *.xlb file back (if you want).

"news.microsoft.com" wrote:

Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike

"Dave Peterson" wrote in message
...
Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you
mean
them
all???????)

If you're only concerned with the rightclick that shows up when you're
in
a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see
that
on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar,
though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut
menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and
re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Cut, Copy, Paste, PasteSpecial grayed out.

Glad it worked--but still curious why resetting the Cell popup didn't.

"news.microsoft.com" wrote:

Dave, this worked!
Deleting the .xlb file and having Excel replace it reset my right-click
shortcut menu.
Thanks for all your help!
Mike

"Dave Peterson" wrote in message
...
Try it again.

If it doesn't work, share what rightclick menu you're trying to reset.

===
You can reset all the toolbars if you want.

(Saved from a previous post)

The first thing I would do is reset my toolbar by deleting the associated
toolbar file (*.xlb).

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're
worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you
could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed
on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.

And delete/move them.

Then reopen excel and do some minor modifications. Then close and reopen
excel
to see if it worked.

If it worked, make your real changes.

If it didn't work, put your *.xlb file back (if you want).

"news.microsoft.com" wrote:

Dave,
Adding this command to the immediate window did not correct the shortcut
menu. Items are still grayed out.
Any other ideas?
Thanks,
Mike

"Dave Peterson" wrote in message
...
Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you
mean
them
all???????)

If you're only concerned with the rightclick that shows up when you're
in
a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see
that
on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar,
though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut
menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and
re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cut, Copy, Paste, PasteSpecial grayed out.

The command worked for me. Thanks!

Dne pondÄ›lÃ* 7. prosince 2009 23:09:48 UTC+1 Dave Peterson napsal(a):
Sorry, I didn't notice the shortcut problem...

There are a bunch of rightclick areas that you could mean (or do you mean them
all???????)

If you're only concerned with the rightclick that shows up when you're in a
plain old cell in the worksheet when you're in Normal view:

Go into the VBE (alt-f11 is a quick way)
hit ctrl-g (to see the immediate window)
application.commandbars("Cell").reset

"news.microsoft.com" wrote:

Dave,
BRILLIANT!!!
That worked for the Main Menu Bar!
The Shorcut (right click menu) still does not work and I don't see that on
the list.

Any idea how I can reset or repair that one?

Thanks,
Mike
"Dave Peterson" wrote in message
...
I'd try this first.

Rightclick on an empty spot on any of the toolbars.
Choose Customize (at the bottom)
Toolbars tab
Select worksheet menu bar
and click reset

And see if that helps.

You will lose any customizations you've made to that toolbar, though.

"news.microsoft.com" wrote:

Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.

--

Dave Peterson


--

Dave Peterson


  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cut, Copy, Paste, PasteSpecial grayed out.

On Monday, 7 December 2009 15:46:00 UTC-3, Simon Lloyd wrote:
Can you check to see if Ctrl+C and Ctrl+V work? if not it sounds as
though they may have been prevented via code.

You could check to see if the worksheet or workbook structure has been
protected, does this happen on a brand new instance of excel i.e Book1?

news.microsoft.com;579911 Wrote:
Puzzling problem: In Excel both under "Edit" and in the shortcut menu
"Cut",
"Copy", "Paste" and "PasteSpecial" are grayed out.

Just started today.Files are not protected.

These commands work fine in Word and Outlook. Have closed and re-opened
Excel. and Rebooted the computer to no avail.

Can someone help me?

Excel 2003,(Office 2003 Pro) Windows XP Pro SP3 Tablet Edition.



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: 1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160357

Microsoft Office Help


SIMON LLOYD u area genius..thank you

it came back with the ctrl c and ctrl v
great!!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/pasteSpecial transpose, does not work. Andy Smith[_2_] Excel Discussion (Misc queries) 0 September 14th 09 10:36 PM
Copy/pasteSpecial transpose, does not work. Luke M Excel Discussion (Misc queries) 0 September 14th 09 08:58 PM
Copy Chart and PasteSpecial PCLIVE Charts and Charting in Excel 2 October 26th 06 03:01 PM
Copy PasteSpecial not working Richard Buttrey Excel Worksheet Functions 9 August 11th 06 04:40 PM
Automate Copy / PasteSpecial carl Excel Worksheet Functions 1 March 29th 06 07:07 PM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"