I am using Excel 2000
I have recently opened a file sent to me, and since closing it my Edit menu does not work properly when I open any existing files or start a new file
The problem is with Copy, Cut Paste and Paste Special, when I click on the Edit menu they are all greyed out, also if I right click they are also greyed out
Obviously the file I opened has changed some settings, how do I re-set this
I would like my custom menus to act like builtin menus - specifically I would like them to be disabled (grayed out or even entirely removed) when the application is in Cell Edit Mode (I cant believe I am the first to ask about this but I cant find the answer elsewhere).
It sure seems confusing to offer users access to a seemingly active command when it does not run (in edit mode I mean).
I send huge lumps of Karma to any willing to share ideas or solutions.
I have created a sub to add new controls to the "Cell" shortcut menu. Can I remove the standard "Cell" shortcut menu controls? if so how do you do it?
[Code] ......
I have a workbook with multiple sheets. Is there a tool that creates a menu bar or code that I can add that would support navigation?
My goal is to have something with approximately 4 options (buttons?). They would link to 4 different sheets that serve as indexes within the workbook.
I know I can add a control like a button to a given sheet that would take the user to given sheet when clicked, but can I make the button 'float' above all the sheets, or add to a menu bar, or something? I just don't want to have to add the button to every sheet in the workbook.
I am looking for something simple/easy, and am not looking for anybody to do the work. I just have no idea on how to approach the problem.
I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..
View 3 Replies View RelatedI'm adding a menu selection to the right-click menu that you get for cells. I can add and remove the menu option but, when I try to execute the macro tied to the menu, I get "the macro...cannot be found". I can't figure out what appears to be a "pathing problem". I'm sure it's simple but...
Here's the
I have actually got the Window menu in the Main Menu Bar of excel deleted using below command.
Application.CommandBars("Worksheet Menu Bar").Controls("Window").Delete
Now this is something which I dont even know if it can be done, but its something which I would use, a lot. When clicking on a button, like a normal button from the control toolbox, is it possible to open a menu from this? So I click on the button i made called "accounts" and this opens a menu next to it with different options.
View 5 Replies View Relatedmy worksheet menu bar is displaying the ' Chart' menu no matter what I do. Not only do I have no charts in the workbook, (verified this by: )
For Each ws In Worksheets
ws.Select
MsgBox ActiveSheet.ChartObjects.Count
Next ws
but adding worksheets, selecting various parts of a worksheet, creating a chart and deleting it, and everything else I've tried has no effect.
One interesting thing - the first chart I added (to test if it would 'unstick' itself upon deletion of the new chart) was named 'Chart 2', implying there was a chart1 that existed previously.... although I am fairly certain I never added a chart to this workbook at any point.
Also, the menu bar is working fine in other workbooks, and changes to chart and back to data like normal.
Suppose I delete a (unknown) number of items from the Worksheet Menu Bar. This can vary because of the fact that my excel sheet is being used by a different number of people, all with a different Worksheet Menu Bar configuration. Is there a way of counting how many Menu items are still left in the Worksheet Menu Bar?
So, suppose all that is left (after using the program) in the Worksheet Menu Bar are Excel, File, Tools, Help. How can the porgram find out that there are only 4 items in the menu?
I am taking an EXCEL(online) class and in my current assignment i am to create a 'list' for sorting and querying. However i cannot find the 'list' option, under my DATA option on the toolbar. I have tried all my toolbars and shortcuts but I am unable to find it anywhere.
View 9 Replies View RelatedI have made an excel addin named "INDNUMFOR" and want that this should display under "Data" of main menu bar. thus, a new item (sub menu) should appear naed "IndNumFor" under Data main menu.
View 9 Replies View RelatedIs it possible to edit my .bat file using vba?
View 1 Replies View RelatedIs there a way to setup a spreadsheet so data that has been entered cannot ne deleted or edited, and only the last field in the column can be accessible? So if I have info entered in a1, a2, a3, b1, b2, b3, no one can edit or delete them, and can only add to a4 and b4? Will I need to write a macro for this or is it something I can do with certain settings?
View 9 Replies View RelatedThe edit box used to make or edit ranges for Defined Names is VERY difficult to use for long char strings. The arrow keys do not move the cursor within the edit box & the end key does not work.
How to edit range names that are 100-200 characters long?
Are there settings to alter behavior of arrow keys withing these "range definition boxes"?
I have an autoshape with a text box in it. It is one of those "scroll" shapes. I want to be able to edit the text in the box with VBA, but I don't know how to call it because I can't seem to find the properties for it. I tried recording a macro to do it, and it called it:
View 5 Replies View Relatedhow to set up and/or edit my macros so that I can use them in various outside workbooks without having to open the specific workbook I put the actual macros in?
View 2 Replies View RelatedWhen I list my macros using alt+F8 the edit option is no longer available, any ideas what I have done?
View 9 Replies View Relatedhow can I open a .txt file with vba and replace alll "," with ";" ?
I am facing problem with my footer, which is as under:
___________________________________________
E-mail: xxx_yyyy@somewhere.com
My footer should be printed at the bottom of my paper as shown above. But, as expected, when I change margins of page or even change the printing preference, like best print to draft print or like that, it goes changing like this:
________________________________________________E
-mail:xxx_yyyy@somewhere.com
or like this:
_________________________________________________
__E-mail:xxx_yyyy@somewhere.com
So, it become headache for me. i have to first see the print preview and then after I can go for printing. How to deal with this problem?
There should be two lines in footer: first will have _____________________________________only and the second one will have E-mail:xxx_yyyy@somewhere.com
My purpose is to give my endusers a workbook with a macro in it which applies changes to existing workbooks on their computers. I want the enduser to select each workbook to apply the changes and have the macro capture the names of the workbooks so they can verify that all of the appropriate workbooks have been changed.
I’m trying to change two types of data: (1) text, (2) formulas.
Here's what little I have, but not much is working.
Sub ChangeBACKLOG()
MsgBox "Open the FILE to which the Backlog fix is to be applied."
Dim targetWorkbook
dlgSource = Application.Dialogs(xlDialogOpen).Show
Set sourceWorkbook = ThisWorkbook
Set targetWorkbook = Workbooks.Item(Workbooks.Count)
On Error Resume Next
I've been trying to resolve an issue with the userform that i created. It adds new records to the sheet "Data" but i can't seem to add a search/edit function to it.
It could be either a combobox with the existing Project Id's or a text box + a control button, so a user could enter Project Id and hit a button.
The spreadsheet example is attached : Project Entry Form.xls
Is it possible to edit multiple =VLOOKUP formulas to add in a "[range lookup]" = FALSE without editing each one individually? I was going to use a find and replace for the "col_index_num" and add the FALSE to the end of that, but in this case my "col_index_num"s vary too much.
View 6 Replies View RelatedI have a sheet which has many columns in it, all columns are protected except column B. When I want to enter data always I have to insert a column in column B. When I clicked insert button, my B column move to C and B column become protected and C become unprotected. My query is always I want B column should be protected (even if i clicked on insert column button too).
View 1 Replies View RelatedI suddenly can not edit in a cell by double-clicking on it. I can only edit in the fx bar on top. Other sheets in the workbook still work normally. What causes this, how can I fix it and how can I make sure it doesn't
View 5 Replies View RelatedI need to edit the hyperlinks in my excel sheet. I know how to do this manually and edit one at a time, but I need to change 3000 of them!
Is there a way I can do this without going through each one?
i have an excel sheet that has a cell with a formula in it. This cell has been locked by the previous user.
I am unable to click on it and it because it is showing a #NAME? error, i need to edit it somehow. Is there some way i can edit it?
The formula below works apart from the first bit which i want to be if F23 says 'fail' then i want the cell to say 'no dissertation' but if f23 says pass then i want the formula past that bit to be put into action.
=IF(F23="Fail",0)*IF(COUNTIF(B22:B45,"Dissertation")=1,IF(VLOOKUP("Dissertation",B22:C45,2,0)>39,LOO KUP(F26,{0,40,50,60,70},{"No Dissertation","3rd","2:2","2:1","1st"}),"No Dissertation"),"No Dissertation")
isolation123
Heres a strange thing, My latest version of a spreadsheet i have design has got a small problem. When clicking on a cell, nothing appears in the edit window, and when you double click on the cell to edit the contents the data disappears.
This only happens on one sheet within a workbook of 7 pages. The werid thing is that it does not happen on the version before
Any ideas how this could of happened and is there a fix?
I've read a bit on the web about there being a bug with the 'edit links' feature. How/Can I get this function to work?
View 6 Replies View Related