There is something that is bothering me in excel. Every time I open a workbook, on my toolbar appears the "Reviewing" one. I tried to unchecked it from the customize toolbar option but still appears on opening a new workbook ((.
View 2 RepliesUpgraded to Excel 2013. Do i no longer have the ability to customize the look of my macro buttons i add to the toolbar?
View 2 Replies View Relatedwhich of these toolbars provides the better 'controls' to paste onto worksheets (as opposed to UserForms)? For those wondering, both toolbars contain some apparently similar controls, e.g., combo box, radio button, spinner etc. but there are differences in their behaviour it would seem...
View 2 Replies View RelatedI have a sheet with part protection and have 4 columns that I want to enter data. Need advice on macro -columns cdef. When data in column c entered, go right two columns, enter data in column e, go right, enter data in column f, and go down, and back, to column c. That is on the next row down ready to enter next set of data.
View 2 Replies View RelatedI have utilized the search button here, but alas haven't found exactly what I am looking for. I have run into a wall and cannot seem to scale it. I am running excel 2000 and need some assistance with creating a search macro. I have a simple spreadsheet created with 3 columns and 500 rows. Column A is name, B is a given # and C is employee status. What I need the macro to do is once a user enters the employee #, it highlights and takes the user to the corresponding name (Column A). I apologize for asking a "novice" question, but i have very little experience in this side of excel.
View 5 Replies View Relatedexcel data table within the charts. I would like to customize the data table placing underneath the chart so I can highlight (say, in red) some of the figures that are greater than certain values for easy reference. Is there anyway I can do with it (since I got more than 800 charts) than that I can only use tools to draw a rectangle and cover that particluar cells up? or is there any ways I can link up the conditional formatting of the data itself with the chart so I can applying certain coloring on the data and reflect on the data table?
View 3 Replies View RelatedI currently have a template that I have made and all the info and everything is fine on it, but the problem is with printing. Every time I go to print it wants to print out 100 copies of the same thing. I tried editing the original template by printing 1 copy then saving the template, but it still wants to print 100 copies with the next try. how to customize what the print settings are for the template and make them stay permanent with the template?
View 4 Replies View RelatedHow can I get from this:
Random Item name;random_nickname Final price: EUR 1.00 (Fixed price)
this:
EUR 1.00
I have excel 2003
I would like to identify text cells of my document containing names of speakers in a conference with their nationality. I would like to do that by setting the background of the cell with the national flag of the country where the speaker comes from.
I tried to select the flag as an image and put it over the name with trasparency but then it result very not convenient to modify the text in the cell and the image makes the worksheet very heavy
I'm trying to allow a user to chose from four different variables through combo-boxes as their Y and X coordinates to be displayed in a scatter plot. I'm able to populate the combo-boxes but don't know where to go from there to apply this to a chart.
View 9 Replies View RelatedI have been attempting to enable the developer tab in Excel 2013, and have been unable to do so. When I check the box for the Developer tab, then click OK, the ribbon flickers, as if the tab is being added, but then the tab does not appear. When I go back to customize the ribbon, the check for the Developer tab is again not checked. I have also tried to move things around to different tabs and none of the changes stick.
View 9 Replies View RelatedWith a scatter chart, you can use the following vba to set maximum and minimum category values on a scatter chart. Is the same possible for a line chart and if so, how?
With ActiveChart.Axes(xlCategory)
If Range("S6").Value "" Then .MinimumScale = Range("S6").Value
If Range("S7").Value "" Then .MaximumScale = Range("S7").Value
I'm using Excel 2003 and am unable to find the name of, and therefore customise, the right-click shortcut menu that pops up when you right-click on a line drawn from the 'Drawing" toolbar. Basically, I'm trying to do some technical analysis on a chart. I want to be able to right-click on the lines that I draw on the chart and replicate a parallel line.
View 3 Replies View RelatedI have an Active X SpinButton control directly on a spreadsheet that changes the input cell. (The idea is that later on, there'll be a bunch of these input cells, accompanied by their respective SpinButton controls).
I'm allowing the user to define the Min, Max, and Step (SmallChange) value of the SpinButton because (1) I need it to do decimal points and negative numbers and (2) that's what my boss would have wanted.
So I set the Min, Max, SmallChange value in the SpinButton properties to "0" then try to manipulate them in the VBA code.
What went wrong with the code is hard to explain. But basically, when I use the SpinButton to increment or decrement, it didn't quite do it correctly. If I fix the increment part of code, then the decrement part of the code goes wrong and vice versa.
An example: I have Min as "0.5%" in cell B7; Max as "4.5%" in cell B8; and Step (SmallChange) as "0.5%" in cell B9. The Input cell is in cell B10 where user can either type in a value within the defined range (enforced by data validation) or use the SpinButton to change the value.
To replicate the problem: I type in "1.0" in the Input cell and click on the left SpinButton and it would not allow me to go to the defined lower limit (which is 0.5%) in this case.
Here are my codes:
Private Sub SpinButton1_SpinUp()
Dim MyMax As Variant
Dim MyStep As Variant
Dim MyInput As Variant
MyMax = SpinButton1.Max + Range("B8").Value
MyStep = SpinButton1.SmallChange + Range("B9").Value
MyInput = Range("B10").Value...................................
I've got an Excel file that I'll be offering for download. I'd like to customize each copy for each user as they download it from the server and am trying to figure out if this is possible & what technology I'd need to use to do so. Simply, I'd like to edit a range in a document, lock it with the built in Excel password protection, and then resave it for the user. Is it possible to write a script to do this w/o opening the file? Any ideas on what technology I'd need to use to do so (.NET framework? OWC?)?
View 4 Replies View RelatedHow to add the macros in existing excel ribbons.
For example - I have a two macro codes. One is change the Date Format from DD.MM.YYYY to MM/DD/YYYY and another one is Date Format from MM/DD/YYYY to YYYYMMDD.
I want to execute the macro from the customize ribbon through Add in Buttons.
See the attachment : Customize the ribbon with Macro code.jpg
How does one add files/templates to excel2010 to customize scroll bars, graphic-like or clip-art type?
View 1 Replies View RelatedI have an excel sheet with multiple pivot tables. I would like to customize the output based on a criteria when I double click on these pivot tables. Criteria could be different for each pivot table. Criteria for each pivot is to auto fit the contents, delete certain columns and format the contents.
View 1 Replies View RelatedIs it possible to remove all gridlines (except in a table) and change the background colour to plain colour (except the table) in Excel 2010?
View 2 Replies View RelatedI have a product list where each row of the worksheet has an image, product details and suggested lists/retails for each local currency.
Some products are not available in certain countries and each market doesn't care to see the other market info. (There are hundreds of items and dozens of countries.)
How can I create a drop down selector so that a user can choose their market, i.e. "Australia," and only the rows and columns relevant to them appear?
Can this be done without macros,? This sheet is distributed among 100+ people and needs to work for lowest common denominator.
I would like to add some icons on the left side of excel open file pane to faciliate my work. Because i need to load some files under the same folder many times a day. Does anybody know how to do that? I've seen people has more icons on the pane before. The defaut setting has only 'History', 'My Documents', 'Favorites', 'Desktop' and ' My nutwork places' on it.
View 2 Replies View RelatedI've recently got a new computer and this problem is driving me nuts.
When I click view!toolbars!drawing, nothing happens. No drawing toolbar appears at the bottom of the screen where it used to be. There's a small "drawing toolbar" icon on the main toolbar, but whether this is depressed or not makes no difference either.
I understand this may be changed in the 2007 version, but I’m using Excel 2000
I downloaded the calculator toolbar, and for some reason it doesn't look right, it doesn't resemble a calculator layout at all.
The numbers are skewed, as though the layout is in landscape view instead of portrate. I've tried repeately to delete it from the toolbars menu option, with no success. It's become annoying.
I have a project management workbook I created that tracks the status of projects and their associated "grocery list" of items being pursued to complete each project. The user needs to indicate the status of each grocery item by setting the item red, yellow, green, or blue; each color has an associated number (1, 2, 3, 4) so the overall project status can be averaged. I am currently using a command button and Select Case statements to allow the user to toggle through the various status colors with a single button. The problem is, I still have to have a separate command button on each sheet which takes up a lot of space.
I would like to have a single toolbar that is available on all sheets, much like an Add In creating a menu, but it is impossible for me to personally install a custome toolbar or an Add In on each user's PC. I need something imbedded in the actual workbook that will propogate the toolbar on its own.
how i can create a replacement toolbar within excel, that will run once the file is opened. replacing the file, edit, etc.
View 3 Replies View RelatedI know excel already has a buildin "sum" function. But since I want to customize the "sum" function so anyone can show me how to write the "sum" by our own? Thanks
View 10 Replies View RelatedI have a macro and I want a button on the toolbar, once clicked on the button, I want the macro to run.
Is there any way to do this. If this can be done using add-ins, I doesn't know how to create a button for the same.
I use Excel 2000.
I want to hide all toolbars when I work.
I know how to hide them during a session, but when I exit and reboot Excel, the "standard" toolbar always returns.
Is there some way to hide the "standard" toolbar permanently?
I am running Excel 2003 and in my workbook I created a macro and assigned it to a toolbar comman button, "Copy Filtered Data". This macro copies the visible data into a new workbook.
This works well but others in my company will also be accessing this workbook from a sharepoint and I discovered that when they open it this command button is not on their toolbar.
Would anyone know what I need to do to have this button load on the toolbar when the workbook opens?
Also, I would like this button to either unload or greyout when the workbook that this button is intended for is closed.
I have created a toolbar button to save a file as a specific name based on a cell value. The macro runs fine, but the button changes priority when the new file is saved.
i.e. the original file is called "quoting_tool" and the newly created file is called "quoting_tool_'B3'". However, the next time I click this button in the original file, it requests the new file as the home of the toolbar button. I have tried saving the original file after adding the button, but that doesn't work.