xlsm

  1. D

    Insert Username without VBA

    Hi All, I'm keen to add a field to a spreadsheet that populates a cell with the username of the last person who edited the file, as in the system or logon name, e.g. first.lastname syntax. I would however like to keep this sheet as an .xlsx and not have it as an .xlsm. I have the code to use...
  2. J

    Problems with saving as .xlsm

    Hi All, Using: Office 2007 I have taken on a design spreadsheet from a colleague which is in .xls format. I want to produce MS word docs using data taken direct from the spreadsheet and so I have written VBA/Macro in word to do this. However, the excel doc will not save as a .xlsm spreadsheet...
  3. B

    EXCEL 2013 won't save 2003 XLS file as XLSM

    I have an EXCEL 2003 xls file with embedded macros. Just installed EXCEL 2013 on new computer and after opening 2003 file, tried to convert/save as 2013 XLSM (macro enabled) version. Went through Convert/Save as XLSM/SAVE, but after Clicking "Save" the dialog goes away but no file is created...
  4. C

    XLSM file loads but no contents are displayed for one user

    An XLSM file that was created in Excel 2010 is on a network share. The file is accessed by a dozen employees, all using 2010. It opens quickly & appears fine for all but one person. The file seems to load on her PC (the properties are accessible) but nothing is visible. There is a prompt to...
  5. G

    Save xls to xlsm, but only a reload gives 1000000 rows

    When i open a xls file in excel2010 i have 65536 rows. After SaveAs xlsm there still are 65536 rows After closing and reopening the file, the 1000000 rows appear. Do i have to re-open the file? Why: We use different EXCEL versions. The advanced users have EXCEL 2010. Our mainframe starts...
  6. B

    Skip warning when save as xlsx when VB project present

    I have a workbook with an ActiveX button that makes a copy of the activesheet and emails it. I figured out how to remove the button from the copied sheet and how to save it as xlsx instead of xlsm. However, how do I stop Excel from warning me that I am saving it in this format and my VB...
  7. J

    Temp file not saving macros

    Hello! I've created a form for my work colleagues to complete when they want to start a new project. The form is completed by the project leader, then they hit a Command Button and it's sent to the Senior Manager. After the Senior Manager looks at it and approves it, he then sends it on to Admin...
  8. J

    Custom Ribbon Stripped Out of .XLSM

    Custom Ribbon Bar Stripped Out of .XLSM I have a mini-application that has been upgraded from Excel 2003 to Excel 2007. This upgrade involved replacing the custom application toolbar with a custom ribbon bar which consisted of creating a customui folder and customui file embedded in the .XLSM...
  9. S

    Macro/VBAProject to copy entire .CSV to Sheet2 of active Workbook (xlsm)?

    So here's the situation... I have an Excel 2007 .xlsm file that only contains Sheet1. I have two options, but the outcome has to be the same... Options Option 1: Have a "Load CSV" button on Sheet1. When clicked, the user needs to find a .csv file and Open it. Option 2: Press Alt+F8 to run...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top