Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet tabs
Running 2007 on windows xp. All of the sudden I cannot right click on the
worksheet tabs. I right-click and nothing happens. I need to do this to copy and move worksheets around. Does anyone have any idea why this is happening or how to fix it or how to get around it? Recently, I installed and uninstalled some add-ins, and my guess is that the add-ins changed a property somewhere. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet tabs
Try this...
Open excel Hit alt-f11 to get to the VBE (where macros live) hit ctrl-g to see the immediate window Then type this and hit enter: application.commandbars("ply").enabled = true Then back to excel to test it. If it didn't work, try entering this command (and hitting enter) in the immediate window of the VBE: application.commandbars("ply").reset Estimator wrote: Running 2007 on windows xp. All of the sudden I cannot right click on the worksheet tabs. I right-click and nothing happens. I need to do this to copy and move worksheets around. Does anyone have any idea why this is happening or how to fix it or how to get around it? Recently, I installed and uninstalled some add-ins, and my guess is that the add-ins changed a property somewhere. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet tabs
The first statement worked. Thanks Dave!
"Dave Peterson" wrote: Try this... Open excel Hit alt-f11 to get to the VBE (where macros live) hit ctrl-g to see the immediate window Then type this and hit enter: application.commandbars("ply").enabled = true Then back to excel to test it. If it didn't work, try entering this command (and hitting enter) in the immediate window of the VBE: application.commandbars("ply").reset Estimator wrote: Running 2007 on windows xp. All of the sudden I cannot right click on the worksheet tabs. I right-click and nothing happens. I need to do this to copy and move worksheets around. Does anyone have any idea why this is happening or how to fix it or how to get around it? Recently, I installed and uninstalled some add-ins, and my guess is that the add-ins changed a property somewhere. -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
Worksheet tabs at top | Excel Discussion (Misc queries) | |||
worksheet tabs | Excel Discussion (Misc queries) | |||
Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
Worksheet Tabs | Excel Worksheet Functions |