?
Solved

Excel 2007 Past Command, Sheet Menu

Posted on 2011-05-11
2
Medium Priority
?
188 Views
Last Modified: 2012-05-11
I lost the menu to manipulate sheets, as well as the paste command is now greyed out, and I cannot use keyboard shortcuts - Alt, Edit, Special Format Paste - or whatever it is, I can do it automatically...  I can put this command into the VBE editor to get the first two back temporarily, but I need it to be permanent.  Application.Commandbars("Ply").enabled=true.  Nothing has helped the keyboard shortcut.  A previous answer said go to document and settings and rename the profile of the user.  Windows 7 does not appear have "Documents and Settings as an option any more.  I was unable to find anything that looked like a profile of the user (which is me, and I am the only one).  Thanks.
0
Comment
Question by:PatriciaGayler
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 35741737
Check in:
C:\users\user_name_here\appdata\roaming\microsoft\excel
and see if you have an .xlb file in there. If so, rename it and then start Excel and see if the problem is resolved.
0
 

Author Closing Comment

by:PatriciaGayler
ID: 35927027
I apprecated the additional information that told me exactly where to find the file.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question