macros disabled

Hello, For years, my company has used a template in OneNote for each customer. Each page contains an excel file that contains macros. Now, I believe a new update by Microsoft has disabled macros within OneNote. The excel file works fine from a desktop, but when opened inside OneNote it...

I am working on a spreadsheet of a staff schedule and I want to add macros so that each staff can only see their shifts and have a RESET button to see the entire schedule. However, I do not want all the staff to see all the schedule. Is is possible to put a password on the RESET button so that...

I have a spreadsheet that has numerous macros within it across multiple sheets. I send this spreadsheet to others outside of my company, but the "Macros have been disabled. Enable Content" warning always shows up when the spreadsheet is first opened. I understand the security measures, but is...

Hello, I've created several UDFs, they were working just fine, but after I saved and reopened the workbook all of them have been returning #NAME error just like Excel could not locate them. They were saved in standard code module. I've played a little bit with Excel trust settings, reopened the...

I have an Excel 2010 workbook which contains many macros. However, they have now stopped working and I get the warning "Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled". I have got into Macro Security and "Enabled all macros" but they still...

Hello, I use to know how 2 reset so my macros would start working again, however I've forgotten how!!! Can someone please help me!!! Thanx!!! :confused:

What is the best way to check if someone has Macros disabled and what is the best way to walk them through Enabling Macros if they happen to be disabled. Preferable using VBA Workbook_Open()