macro-enabled

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...

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...

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...

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...

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...

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...

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...

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)...

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...

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...