Remove Green Sharing Checker in Excel 365: A Comprehensive Guide
Microsoft Excel 365 has introduced a green sharing checker box that appears in the bottom right corner of the workbook. This feature allows users to quickly see if a workbook is shared and provides options to manage permissions directly from the Excel interface. However, some users might find this feature distracting and prefer to remove it. In this article, we will provide a detailed guide on how to remove the green sharing checker in Excel 365.
Understanding the Green Sharing Checker in Excel 365
The green sharing checker in Excel 365 is a small window that appears in the bottom right corner of the workbook when it is shared. The checker shows the number of users who have access to the workbook and provides options to manage permissions and sharing settings. Here are some key concepts to understand about the green sharing checker:
- The green sharing checker appears when a workbook is shared.
- The checker shows the number of users who have access to the workbook.
- It provides options to manage permissions and sharing settings directly from Excel.
- The checker can be distracting for some users and might interfere with their work.
Removing the Green Sharing Checker in Excel 365
To remove the green sharing checker in Excel 365, follow these steps:
- Click on the File tab in the top left corner of the Excel interface.
- Click on the Options button in the left-hand menu.
- Select the Advanced option from the left-hand menu.
- Scroll down to the "Display" section.
- Uncheck the box that says "Show sharing indicators".
- Click OK to save the changes.
After completing these steps, the green sharing checker will no longer appear in Excel 365. If you need to access sharing settings in the future, you can re-enable the sharing indicators by following the same steps and checking the "Show sharing indicators" box.
Alternative Method: Using VBA Code
If you prefer to use VBA code to remove the green sharing checker in Excel 365, you can use the following code:
Sub RemoveSharingChecker()
Application.DisplaySharingIndicators = False
End Sub
To use this code, press Alt + F11 to open the VBA editor. Then, insert a new module and paste the code. You can run the code by clicking the Run button or pressing F5. The green sharing checker will be removed immediately from the Excel interface.
In this article, we have provided a detailed guide on how to remove the green sharing checker in Excel 365. We have explained the key concepts of the green sharing checker and provided step-by-step instructions on how to remove it. We have also provided an alternative method using VBA code. By following these instructions, users can remove the green sharing checker and improve their Excel experience.