Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel is removing Macros from workbook
Hello,
I have a workbook.xlsm that when some users open the workbook Excel complains that the Marcos are corrupt and then proceeds to strip out all the Macros from the workbook. I am able to open the file in 2010 and 2013 without any issues. In both instances the users had a computer that had a fresh install of both windows and Excel. Any insight would be greatly appreciated. Thanks, Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel is removing Macros from workbook
wrote:
I have a workbook.xlsm that when some users open the workbook Excel complains that the Marcos are corrupt and then proceeds to strip out all the Macros from the workbook. I am able to open the file in 2010 and 2013 without any issues. In both instances the users had a computer that had a fresh install of both windows and Excel. My guess: the users having trouble have set their macro security too high (which is the default after a "fresh install"), and they are misinterpreting the Excel error message and circumstances. If they are using XL2010, for example, they should click on File, Options, Trust Center, Trust Center Settings, Macro Settings. I prefer the setting "Disable ... with notification". That gives me full control. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel is removing Macros from workbook
On Thursday, November 21, 2013 12:12:07 PM UTC-5, wrote:
Hello, I have a workbook.xlsm that when some users open the workbook Excel complains that the Marcos are corrupt and then proceeds to strip out all the Macros from the workbook. I am able to open the file in 2010 and 2013 without any issues. In both instances the users had a computer that had a fresh install of both windows and Excel. Any insight would be greatly appreciated. Thanks, Michael Thanks joeu2004, I saw the error messages about the corrupt macros, the security is set for "Disable .... with notification" In both instances Office 2013 was installed first and then the users downgraded to 2010. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel is removing Macros from workbook
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing password protection from an Excel workbook | Excel Discussion (Misc queries) | |||
Removing Macros when saving a copy of excel file | Excel Programming | |||
Excel cores when trying to close a workbook after exporting+removing VBA modules | Excel Programming | |||
Removing macros from workbook | Excel Discussion (Misc queries) | |||
Removing Macros | Excel Programming |