macro-enabled

  1. J

    VBA - Copying Worksheet from Named workbook and pasting to "Macro-enabled workbook and named worksheet"

    Hi, I have a macro-enabled workbook with a calculation table These are the steps I need help with. 1. I wish to copy the sheet of a downloaded workbook, however, the workbook is "$XXXX" but when you enable content it changes to "Book1". Ideally I want the original workbook name as it is...
  2. MrDB4Excel

    How to sum intermittent cells per cell fill color

    I have been searching for the better part of 3 hours to find out how to do this, but nothing seems to give an answer that works. I have a sheet where I want to get a sum of the numeric values in the cells that contain fill colour index #46 (kind of a burnt orange). These cells are intermittent...
  3. M

    Excel 2013 Macro enabled workbooks either crash on SAVE or close themselves after Windows Update on some macro enabled files

    About 2 weeks ago we started getting complaints of not being able to open or save macro enabled workbooks created before a Cumulative Windows Update. These workbooks had all worked with no issue for several years up until one of the recent Windows Updates. I can get some of them to open with...
  4. J

    Save "chart in microsoft word" as macro enabled file

    Hello! I am working on a project where I am building charts in a Word file through the embedded Excel feature. Each chart in the Word file has its own mini Excel document. I found some code I was using on another project where, using VBA, it sets the chart axis min and max based on a cell...
  5. K

    Workbook opening very slowly

    I have a large and reasonably complicated workbook, which uses UDF and macros to run a series of processes for analysis purposes. The file itself is 9MB, and this is without any data in it. The purpose of the workbook is that the user pastes a number of comments in Column B of the opening...
  6. R

    VBA To Save As

    Hi, I have a template that I would like users to fill out and then save as a new file name. Quite a lot of the users aren't great with excel and I don't want them to just save the template, I need them to save as. Therefore, I'd like to have a button with an assigned macro that they can press...
  7. M

    BeforeClose / BeforeSave event to save as Excel Enabled Workbook only

    Hi all, I've searched high and low for the answer to this and spent countless hours trying to figure it out, so I am hoping someone out there can figure out what is going wrong. I am putting the final touches on a big VBA project, and my final sticking point is that I cannot for the life of me...
  8. J

    Save As Macro-Enabled Workbook

    I have two macro-enabled templates and I want to force save as macro-enabled workbooks. The following code works fine in one template but not in the other template. Any ideas why it won't work in both templates? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)...
  9. T

    Enable "Delete Worksheet" in macro-enabled workbook

    I have a macro-enabled workbook with a lot of worksheets. I am trying to delete/replace a worksheet but "Delete Sheet" is grayed out in both the "Edit" menu and RtMouseClick menu. "Insert Sheet" is also grayed out. The sheet is not protected and the workbook is not shared. Can someone please...
  10. X

    Macro enabled workbook loses its vba on close and re-open

    I use an activeworkbook.saveas filename:=..., fileformat:=52 statement in vba to save a book for which i have inserted vba into its Thisworkbook Before_Save event procedure. It's there after the save, but when I close and then re-open the newly created workbook, the vba is no longer present in...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top