 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Popup Insert greyed out
Normally to insert a column I would select the entire column, and then using the popup menu select insert....This would insert another column adjacent to the highlighted column... For some unknown reason the insert command on my popup menu is now showing as grayed out.. Using the same method, but for a row instead of a column works OK I have tried removing Excel totally and reinstalling, however the menu still remains greyed out... Any ideas would be appreciated Thank you Stephen What version of excel are you running? If you're running xl2002+, the worksheet could be protected (tools|Protection). xl2002+ has options to allow insertion of rows and insertion of columns. > Normally to insert a column I would select the entire column, and then > using the popup menu select insert....This would insert another column [quoted text clipped - 13 lines] > > Stephen  SignatureDave Peterson Hi Dave, I'm running 2002, I had already checkd the workbook protection and everything is fine. Does it happen on every worksheet of every workbook or just some of the time? If it happens on every worksheet in every workbook, then maybe just resetting that column popup would be sufficient: Open excel hit alt-f11 (to get to the vbe) hit ctrl-g (to see the immediate window) type this and hit enter: application.CommandBars("column").Reset Then back to excel to test it out. ===== You could also reset every toolbar that you've ever used. if you want to try: close excel windows start button|search look for *.xlb and rename all you find to *.xlbOLD restart excel and test it out You'll have to rebuild any custom changes you've made. === If it doesn't work, just rename the *.xlbOLD back to *.xlb (you may have to delete any new *.xlb before you rename the old) > Hi Dave, > > I'm running 2002, I had already checkd the workbook protection and > everything is fine. SignatureDave Peterson Hi Dave.. Some success....by using the "application.CommandBars("column").Reset" it looks like it has now ungreyed the Paste and Paste Special commends, which I'm sure were also grayed previously The Insert however is still grayed Regarding *.xlb...I have searched my drive and can not find any instances of this file ??....Could this be why i have the problem Thank you Stephen Hi Dave. Im not sure why my search didn't come up with *.xlb files, however i checked MS web site and found this file should reside in the users directory structure...Have checked this i have located EXCEL10 file, which i reanmed as per your advise.... Hey Presto...I now have my Insert option back..Problem solved ! Thank you for your assistance and you have a great weekend ! Stephen I didn't notice that the "Row" toolbar was broken, too. You could have tried just resetting that one, too. But if you deleted .xlbold, then that option is gone. Besides, it's always nice to rebuild the toolbars with what you currently need. In fact, once you rebuild that *.xlb file, make a backup of that file. Then if something bad happens, you can just copy the back up into that folder (with excel closed) and you'll be up and running really quickly. > Hi Dave.. > [quoted text clipped - 9 lines] > Thank you > Stephen SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.