Excel - Security Risk Microsoft Has Blocked Macros From Running - Episode 2485
42.3 هزار بار بازدید -
2 سال پیش
-
Microsoft Excel Tutorial - Security
Microsoft Excel Tutorial - Security Risk Microsoft Has Blocked Macros From Running.
Welcome to the MrExcel Podcast, where we bring you the latest tips and tricks for mastering Microsoft Excel. In this episode, we'll be discussing a new security risk that has been causing frustration for many Excel users. If you've recently seen a pink bar with the message "Security risk - Microsoft has blocked macros from running," then this video is for you.
Recently, Kevin Lehrbass, a fellow Excel enthusiast, shared a new Wordle game that he had created on his blog. Excited to try it out, I downloaded the file and attempted to open it, only to be met with the dreaded pink bar. This is a new security measure that Microsoft has implemented, which blocks macros from running if the file is downloaded from the web or received via email. This is their way of protecting users from potential malicious code.
So, what can you do if you encounter this pink bar? First, take a look at the code by pressing Alt+F11. If the code is unlocked and you can see it, check for any potential dangers. Next, consider the source of the file. Do you know the person who sent it to you? Is there a valid reason for them to be sending you macros? In the case of Kevin's Wordle game, there was a clear reason for him to be sending it to me, so I knew it was safe to proceed.
To unblock the file and enable the macros, simply right-click on the file in Windows Explorer and go to Properties. At the bottom, you'll see a section called "Security" with a checkbox for "Unblock." Check this box and click OK. Now, when you open the file again, you'll see the familiar yellow bar asking if you want to enable content. This extra step with the pink bar is Microsoft's way of making it more difficult for bad actors to use VBA to cause problems.
It's unfortunate that this new security measure has made it more difficult for us to use VBA, which is one of the reasons why Excel is superior to Google Sheets. But don't worry, with a simple click of a button, you can unblock the file and continue using macros as usual. And for those of you who love playing Wordle, be sure to check out Kevin's blog post for his amazing Excel version of the game. As always, thank you for tuning in to the MrExcel Podcast. Don't forget to like, subscribe, and ring the bell for more Excel tips and tricks. And feel free to leave any questions or comments down below. See you next time!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked.
This warning is designed to make you ask, "Is there a valid reason for this person to be sending me a macro?" If there is, I will show you the easy steps to unblock the workbook.
This is called the Mark of the Web.
Kevin Lehrbass Word Game is here: https://www.myspreadsheetlab.com/word...
Several people have said they don't have the option to Unblock the workbook. In that case, check out this video about a Trusted Location: Excel From MrExcel: SmartRoster Doesn...
Table of Contents
(0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar.
(1:08) Look at the code
(1:33) How to unblock the macros
(2:10) Dealing with the normal yellow bar.
(2:20) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Analysis tool-pack in Excel
Backing up dates to the first week of the month
Calculating the first day of the month
Dueling Excel podcast with MrExcel and ExcelIsFun
Efficient formulas in Excel
EOMONTH function in Excel 2007
Excel tips
ExcelIsFun YouTube channel
Finding the first Monday of the month
Finding the last Monday of the previous month
Using formula evaluator in Excel
Weekday function in Excel
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Welcome to the MrExcel Podcast, where we bring you the latest tips and tricks for mastering Microsoft Excel. In this episode, we'll be discussing a new security risk that has been causing frustration for many Excel users. If you've recently seen a pink bar with the message "Security risk - Microsoft has blocked macros from running," then this video is for you.
Recently, Kevin Lehrbass, a fellow Excel enthusiast, shared a new Wordle game that he had created on his blog. Excited to try it out, I downloaded the file and attempted to open it, only to be met with the dreaded pink bar. This is a new security measure that Microsoft has implemented, which blocks macros from running if the file is downloaded from the web or received via email. This is their way of protecting users from potential malicious code.
So, what can you do if you encounter this pink bar? First, take a look at the code by pressing Alt+F11. If the code is unlocked and you can see it, check for any potential dangers. Next, consider the source of the file. Do you know the person who sent it to you? Is there a valid reason for them to be sending you macros? In the case of Kevin's Wordle game, there was a clear reason for him to be sending it to me, so I knew it was safe to proceed.
To unblock the file and enable the macros, simply right-click on the file in Windows Explorer and go to Properties. At the bottom, you'll see a section called "Security" with a checkbox for "Unblock." Check this box and click OK. Now, when you open the file again, you'll see the familiar yellow bar asking if you want to enable content. This extra step with the pink bar is Microsoft's way of making it more difficult for bad actors to use VBA to cause problems.
It's unfortunate that this new security measure has made it more difficult for us to use VBA, which is one of the reasons why Excel is superior to Google Sheets. But don't worry, with a simple click of a button, you can unblock the file and continue using macros as usual. And for those of you who love playing Wordle, be sure to check out Kevin's blog post for his amazing Excel version of the game. As always, thank you for tuning in to the MrExcel Podcast. Don't forget to like, subscribe, and ring the bell for more Excel tips and tricks. And feel free to leave any questions or comments down below. See you next time!
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
A new pink bar warning is appearing in Excel, Word, and PowerPoint telling you that there is a security risk and that your VBA macros have been blocked.
This warning is designed to make you ask, "Is there a valid reason for this person to be sending me a macro?" If there is, I will show you the easy steps to unblock the workbook.
This is called the Mark of the Web.
Kevin Lehrbass Word Game is here: https://www.myspreadsheetlab.com/word...
Several people have said they don't have the option to Unblock the workbook. In that case, check out this video about a Trusted Location: Excel From MrExcel: SmartRoster Doesn...
Table of Contents
(0:00) Kevin Lehrbass has a Wordle game in Excel but the macros are blocked with the pink bar.
(1:08) Look at the code
(1:33) How to unblock the macros
(2:10) Dealing with the normal yellow bar.
(2:20) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Analysis tool-pack in Excel
Backing up dates to the first week of the month
Calculating the first day of the month
Dueling Excel podcast with MrExcel and ExcelIsFun
Efficient formulas in Excel
EOMONTH function in Excel 2007
Excel tips
ExcelIsFun YouTube channel
Finding the first Monday of the month
Finding the last Monday of the previous month
Using formula evaluator in Excel
Weekday function in Excel
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
2 سال پیش
در تاریخ 1401/02/13 منتشر شده
است.
42,381
بـار بازدید شده