Today I can't run any macros, on a work computer. Have been able to previously.
Error message is shown ... can't change macro settings either in Trust Center.
Has this been changed by others?
Dear Forum,
I have recently purchased a digital signature certificate to use with my Excel workbooks. My purpose is to digitally sign my VBA code. I am able to digitally sign the workbooks using the signature insert in the workbook ribbon, however, I can't sign the code from the VBA editor...
Any advice appreciated. I've finally gotten passable at VBA/Excel but this issue is weird and when I search I just find articles on how to enable when I want to disable.
I have a report that I edit for a company that is not on my network. I recently started having an issue because after making...
I tried to trust a location in trust center but after I entered a path I got this error message "The remote or network path you have entered is not allowed by your current security settings". What should I do?
Storm.ExcelMacros Suspicious unknown excel Add-in found
Last week running a macro that normally takes 1 min, excel became trapped in a loop “round blue circle still showing in the screen and performance monitor shows processors still working even when I knew the macro was done”.
Troubleshooting...
I have an excel file that will be opened and accessed by hundreds of people, this file is only accessible through a database program so it is not on a network drive per se. The file has some simple code to hide the ribbon and formula bar, however if the file is opened and trust center settings...
Hey everyone
So I have my settings for macros set in the trust center to 'disable macros all macros with notification'. When I open up a workbook that needs macros enabled, I'm not seeing the 'security warning' pop up where I can enable them myself?
It used to show up when I opened workbooks...
I have a pivot table that needs specific settings in the Trust Center. It requires "Enable all macros" and trust access. I have an existing macro that opens this file to extract data. Is there a VBA that would update the Trust Center to allow for this file then revert back to the old...
Hi
I have VBA that will save a worksheet as an .xlsm, but this will cause problems on those users who have not enabled Macros in their Trust Center settings.
My thought was to have an If..Then statement so that the VBA could detect the status of the Trust Center macro settings, and save as...
I have an issue that I constantly get the "macros have been disabled" popup when trying to run my macros and it isn't even constant in the fact that it only stops running macros on one workbook and continues to allow them on others workbooks sometimes. The trust center is still set to allow...
I have a file, that has some sheets that are protected at times and are open at other times (depends on who needs to use them). In it, there are two macros used to make the reports contained in the file update show current activity. The file is one of thirty that are set up the same way. All...
I have a spreadsheet that has links to Outlook email and task templates. Everytime I click them, I get the warning about "Some files can contain viruses. . ." I have added the folder the templates are in to the trusted list and have enabled all data connections and workbook links. The message is...
I have created a spreadsheet with macros. I have created a digital signature and have signed the VB code. I have distributed the spreadsheet to 30 people and have added myself as a trusted publisher to 28 of those computers. I have done this by opening the signed spreadsheet on their computer...
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.