Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy/pasteSpecial transpose, does not work. | Excel Discussion (Misc queries) | |||
Copy/pasteSpecial transpose, does not work. | Excel Discussion (Misc queries) | |||
Copy Chart and PasteSpecial | Charts and Charting in Excel | |||
Copy PasteSpecial not working | Excel Worksheet Functions | |||
Automate Copy / PasteSpecial | Excel Worksheet Functions |