macro enabled workbooks

Hello - I have a PC in my work area with a stripped MS Excel which does NOT open/run worksheets with macros. (Rahter, it will open the workbook, but it will strip the macros from it.) I do use a shared office PC that has the fully licensed Excel and it has full capabilities. My question is: I...

Hi, I want to open a number of macro enabled files, and use the data for consolidation. The problem is whenever the file opens the Enable/Disable macro prompt pops out and user action is to be taken. I am trying to consolidate data for around 50 files, without user intervention. How can I...

I created a workbook with 4-5 conditional formatting formulas (and/or statements). It worked for a few days, but now excel freezes each time I try to open the workbook. Any ideas into why this is happening?

Hey Folks, I have a code in place that emails activeworksheet to a specified sender that i use for requesting information. How does a person email a macro enabled workbook to the same email consistently. Might be an easy question for most of you folks. Any help would be greatly appreciated.

Hi all. I have found a UDF online that does what I need it to do, but I am not sure how to make this function available on all workbooks I open. I know the workbooks will have to be maco enabled, but even upon opening a macro enabled workbook my UDF will not work. Will I have to copy and...