ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet tabs (https://www.excelbanter.com/excel-discussion-misc-queries/254805-worksheet-tabs.html)

Estimator

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.

Dave Peterson

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

Estimator

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
.



All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com