Excel 2013 :: Unable To Customize Ribbon

Jul 14, 2014

I 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


ADVERTISEMENT

Customize Excel Ribbon And Add Button To Execute Multiple Macro

Apr 4, 2013

How 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

View 1 Replies View Related

Excel 2013 :: Customize Macro Button Added To Toolbar

Dec 3, 2013

Upgraded 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 Related

Excel 2013 :: Add In Buttons On The Ribbon?

Jun 24, 2014

I installed excel 2013, but I don't find the (VBA) buttons on the ribbon, since.

Is there a need to install an add in / or activate an add in?

The macro's are on the ribbon on the tab VIEW.

I expect to find the buttons on that place also.

View 3 Replies View Related

Excel 2013 :: Hide And Unhide Ribbon Using Shortcut Key

Apr 14, 2014

i want to Hide & unhide ribbon of excel 2013 using shortcut key

View 3 Replies View Related

Excel 2013 :: Unable To Create Data Form?

Feb 7, 2014

Excel 2013 on a surface tablet and attempting to create a data form. I've followed the necessary steps to try and add the "Form" button to the quick access toolbar, but "Form" is simply not a listed command. Have looked in "All Commands", "Commands not listed in the ribbon" and "Data Tab" and it's nowhere to be found. Not greyed out, just not there.

Frustrating because it's so easy to create a form on past versions of excel. All the tutorials I've seen online explain how to add "Form" to the quick access toolbar

View 1 Replies View Related

Excel 2010 :: Add Files / Templates To Customize Scroll Bars?

Feb 15, 2012

How does one add files/templates to excel2010 to customize scroll bars, graphic-like or clip-art type?

View 1 Replies View Related

Excel 2010 :: Remove Gridlines And Customize Background Colour Other Than Table

Mar 8, 2014

Is 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 Related

Excel 2010 :: Refresh The Ribbon?

Feb 15, 2013

I have an excel tool I am adapting to 2010 from 2003. It imports another tool which has been created elsewhere in my company and it is protected so I cannot alter it. This tool that I cannot change creates its own custom toolbar the "old fashioned" way so it dumps into the add-in tab on the ribbon. My tool opens this corporate tool and changes some items on the toolbar (enters values in a text box) and then imports data from it. However in run-time the custom toolbar never appears. Is there a way to refresh the ribbon in run-time after opening the file so I can then access the toolbar items?

View 1 Replies View Related

Disable Commands Ribbon Excel

Jun 23, 2012

I have the code that accompanies the attached spreadsheet model that locks the copy, paste, cut, double click and so on, with the right mouse button and shortcut keys, however, the toolbar excel these functions still remain active. How well I block access to the toolbar.

Desable_Ribbon.xlsm‎

View 14 Replies View Related

Macro For Minimizing Ribbon (Excel) And Formula Bar

Nov 23, 2012

I have prepared an excel workbook with macros for a bill. In that I have protected the workbook (selected window also) after reduced the menu bar to just ribbon (HOME, INSERT,PAGELAYOUT,.......), so that I would get enough space. I have send it to my friends as WinRaR file. But when they open in their computer the sheet is not getting enough space to display the entire page as normally no body used to minimize the ribbon and formula bar. This is making lot of inconvenience. I tried one macro but it not recording the actions on ribbon.

View 4 Replies View Related

Excel 2007 :: Make Button In Ribbon Menus To Run Macro?

Aug 9, 2013

I've been trying to research how to do this for a while now and still can't figure it out. My impression is that this is fairly straightforward in Excel 2010 since the menus and ribbons are easily customizable but not so in Excel 2007.

So far I can get macro shown as a button in the Quick Access Toolbar. But the issue is that I can't organize them or customize the icons.

Is there an accepted practice for this?

View 4 Replies View Related

Excel 2010 :: How To Assign RELATIVE Macros To Custom Ribbon

Aug 19, 2014

I currently have an excel workbook (2010) in which I created a custom ribbon and assigned several different macros to the buttons.

Long story short, I will be saving several variations of this workbook every so often when I get new data.

The problem is that if I change the name of the file (Save as or Rename), the custom ribbon buttons no longer work. When I assigned the macros to the ribbon buttons, the macros were absolutely assigned.

Is it possible to assign relative macros to custom ribbons?

From research I have done, it appears that custom ribbons cannot be created using VBA. Is this still true?

View 6 Replies View Related

Excel 2007 :: Custom Controls Not Showing In Add-ins Ribbon Tab And XML Error

Jul 18, 2013

We are using Windows7 with Excel 2007. We have old code from excel 2003 and earlier that was adding a msoControlPopup with other sub-controls using the code below:

Code:
Set HelpMenu = CommandBars(1).FindControl(Id:=30010)
If HelpMenu Is Nothing Then
' Add the menu to the end

[Code].....

I tried going to Excel Options>Customize>Reset to reset any customizations to the quick access toolbar as this was recommended by something else I found online. This did not fix the problem.

I can find the control in the Immediate window but it just isn't showing in the add-ins tab. if I can find and repair that XML file perhaps?

View 9 Replies View Related

Excel 2013 :: Mail Merging From Excel Database To Outlook

Apr 15, 2014

Using EXcel 2013, Windows 8

I have an Excel worksheet with one column being e-mail addresses. Other columns are Christian names, etc

Ideally can I create a full Mail merge with Outlook using whatever data I want. But probably just e-mail address and Christian name?

Otherwise be able to send one e-mail to all the e-mail addresses, without a major re-type.

View 2 Replies View Related

Unable To Graph Excel Data?

Feb 9, 2014

I am trying to graph the amount of calls that come in on each day and at what hour. I am trying to put the days of the month along the x axis and hours along the y axis. I then want the number of calls to show as a scatter at certain times on each day. Is this possible? I have attached a sample of a table I will be working with that has made up data on it. I have tried using the select data function to try and change the axis, but I do not think I am writing the correct things in.

View 4 Replies View Related

Excel 2010 :: Unable To Cut Columns?

Jul 25, 2013

I could swear I used to be able to cut and paste columns in Excel 2010, but for the past week I haven't been able to. When I click on a column and do a right click, "CUT" is greyed out. I can cut any section, but not a whole column.

View 3 Replies View Related

Unable To Print Excel File?

Aug 12, 2013

I am unable to print an office file to a certain printer because I am not the author of the file.. when I copy and paste to a new doc I can print no problem.

View 1 Replies View Related

Unable To Open Excel File

Oct 12, 2013

I was able to open and read this file before installing Windows 8.

The background to this is that after installing Windows 8 and reinstalling Windows University 2010 my word documents and excel files where all opening up as word pad documents. I figured out the solution to the above on my own and I am now able to properly read the excel and word documents that I tested. But I am not able to read a very important excel file. It is very important that I restore somehow this file.

When I open the excel file a dialogue box open up saying "Excel found unreadable content in "Account.xlsx". Do you want to recover the content of this workbook? When I choose Yes the following dialogue box opens up saying "Excel cannot open the file "Account.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the extension matches the format of the file".

The file extension is set to xlsx however how do I test to see if it is corrupt. Is there anything I can do to restore this excel workbook?

View 1 Replies View Related

Excel 2010 :: Unable To Delete Rows

May 30, 2014

I'm on mac Excel 2010 and i'm trying to delete rows..but for some reason they don't go! My workbook is a basic one, just filled with a bunch of formulas, i can't understand why it wont let me delete it.

When i do try to delete it, nothing comes happens and when i try to delete a large amount it comes up with 'not enough memory, continue without undo deleting rows' but my laptop has 8GB and my other laptop has 16GB so i can't see why a 16GB laptop wouldn't be able to delete it.

View 1 Replies View Related

Excel 2007 :: Unable To Search The Last Column?

Jul 28, 2013

I've to continue the same sheet made by my bos (I'm using excell 2003, my bos use 2007). However, I'm unable to find the next column which my bos used it. Ex : My last column in excel is IV column. However, my bos's column in more than IV column.

View 2 Replies View Related

Excel 2010 :: Unable To Set Column-width?

Oct 5, 2012

From one moment to another I am not able to set the column width doing the following: right-mouse-button click (the column) and choose column width and then type in the desired width The column width is not set this way.

Setting the column width by dragging the right side of the column works well. Also double clicking the right side of the column (auto width) works fine.

I think I have pressed a certain key combination (I am not aware of) to activate this behavior.

How can I re-activate/enable the above (1st) mentioned method to change the column width?

View 3 Replies View Related

Unable To Access RPT Files In Excel Macro

Dec 7, 2012

I am not able to access *.rpt files in excel macro

By using this below mentioned codes am not able to open the files from folder.

Code:
fpath = "C:Documents and Settings est"
f = Dir(fpath & "*.xls")
Workbooks.Open Filename:=fpath & f

View 4 Replies View Related

Excel 2007 :: Unable To Save As PDF File

Apr 26, 2013

I have an Excel worksheet (2007 version) which I am trying to save as a PDF file. However, the PDF option is not listed in my "Save as type" drop down window.

View 3 Replies View Related

Excel 2010 :: Unable To Select ListBox Items

Feb 11, 2014

I have a worksheet with a few "Multi-Select" type listboxes in it. I cannot seem to select the items within those listboxes... the mouse icon doesn't even change, it just shows that little plus-sign that is the default when you're just in your worksheet. (they're also ActiveX listboxes)

I can select them if I go into my Developer tab and select and deselect the "Design Mode" button. then everything works fine (mostly). Or if I resize the subwindow for the workbook. Then it (again, mostly) works fine.

It's like I have to trick Excel into allowing me to click on the checkboxes in my ListBox.

Some people I've given the file to use Excel 2007 and the file works for them. (I have Excel 2010)

I've looked up info on bound/unbound forms, but I can't tell if it applies, or how to use that. They were not created with a VBA macro, they were made using the buttons in the developer tab.

One final thing : Below the listboxes, I have some shapes that, when pressed, will take the selected items from their respective checkboxes and put them into some cells.

Here is the file: Setup form_Blank.xlsm

View 5 Replies View Related

Unable To Calculate Copy / Paste Data In Excel

Apr 21, 2014

I just copied a table from the web which contains numbers in the last column.

I pasted the data into Excel, but when I try to run any type of calculation i receive a #VALUE! error.

The annoying 'workaround' is to re-type the same numerical text into it's own cell, which allows for calculation.

I've tried changing the cell formatting to 'general', and 'text', but I still receive the #VALUE! error, when trying to calculate.

View 1 Replies View Related

Excel Pie Chart - Unable To Use Sums For Fields / Axis?

Aug 4, 2014

I have a set of data for hours of work. I want to make a simple Pie Chart: % of Hours worked overtime, and % of work not overtime.

The Data Looks something like this:

Name,Normal Hours Worked, Overtime Worked
David,8.0,3.2
Anne,8.0,1.3
Danny,7.0,0.0
Harry,8.0,3.0
Edward,8.0,2.3

So I want a pie chart that has 2 wedges.
~25% labeled as overtime worked
~75% labeled as normal hours worked

Whenever I put these values in the pivot table and use SUM, it is trying to sum based on # of hours matching, instead of by the column Name... so it gets divided into a bunch of different pie wedges.

View 2 Replies View Related

Excel 2007 :: Unable To Enter Any Data In Spreadsheet?

Apr 19, 2008

Very simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...

She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it highlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenly stopped!

View 5 Replies View Related

Excel 2013 :: Average Readings Per Day

Jul 2, 2014

Working in Excel 2013......... I take 3 readings per day, I would like to see the daily average per day

In cases where the data is blank or "0", just average the 2 readings.

Sample Data

Date Speed

6/1/20142560
6/1/20142550
6/1/20142558
6/2/20142554
6/2/20142537
6/2/20142532

[Code] ..........

View 4 Replies View Related

Excel 2013 :: No Column Headers?

Nov 28, 2013

My and a work college needed to combine our separate excel worksheets into a single document.

Office 2013 didn't have a function to "import sheet from file" so we used open office to import my .xlsx worksheets.

After we finished importing we exported the final workbook as .xls (so I could open it).

After opening the workbook on my pc (excel 2013) i notice some of the sheets no longer have column headers, but the row headings still exists. (No ABCD, only 1234)

Also I am unable to use features such as "Freeze Pane"

I suspect this was caused by importing and exporting through open office?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved