D6+ Excel Tools
My Home > My d6+ Excel Tools
My Home > My d6+ Excel Tools
Type <Ctrl> <F> to search for words in the article.
The My d6+ Excel Tools© Excel Add-in can be embedded inside your current Microsoft Excel installation. Please note that embedding is not necessary but is very convenient. To enable this Add-in, please follow the steps below.
Please note that Macros need to be enabled on your Excel installation.
Configuration for Excel 2007
1.Click the Microsoft Office Button
2.Click Excel Options
3.Click Add-Ins.
4. In the Manage box, click Excel Add-ins, and then click Go.
5. Select the checkbox next to the latest version of the My d6+ Excel Tools
6. Click OK .
Configuration for Excel 2010 and higher
1. Click the File tab.
2. Click Options.
3. Click Add-Ins.
4. In the Manage box, click Excel Add-ins, and then click Go.
5. Click on the button, the following screen will appear:
6. Select the checkbox next to the latest version of the My d6+ Excel Tools
7. Click OK.
How to enable/disable macros for excel 2007
This article describes how to enable macros in Microsoft Excel 2007 spreadsheets. To read more about what a macro is:
1.Click the Microsoft Office Button
2. Click the Trust Center button on the left. Then, at the bottom right, select Trust Center Settings.
3. In the new window that appears, choose Macro Settings from the sidebar and select Disable all macros with notification from the list of options that appear. This option keeps macros disabled but notifies users when macros attempt to run, allowing users to decide on a case-by-case basis which macros to enable.
4. Click OK to exit this window.
5. For the new settings to take effect, it will be necessary to close Excel and reopen it. A security dialog box should appear beneath the Office ribbon the next time you attempt to run a spreadsheet that contains macros.
6. When the notification appears, click the Options button.
7. Choose Enable this content from the options that appear to allow macros to run within the current spreadsheet.
8. Click OK to close the window.
NOTE: If this doesn't work, try refreshing the worksheet.
How to enable/disable macros for excel 2010 and 2013
Macro settings are located in the Trust Center. However, if you work in an organization, the system administrator might have changed the default settings to prevent anyone from changing settings. IMPORTANT When you change your macro settings in the Trust Center, they are changed only for the Office program that you are currently using. The macro settings are not changed for all your Office programs.
1. Click the File tab.
2. Click Options.
3. Click Trust Center, and then click Trust Center Settings.
4. In the Trust Center, click Macro Settings.
5. Make the selections that you want.
6. Click OK.
© Copyright d6 group (Pty) Ltd.
Related Articles
My d6+ Excel Tools
My Tuiste > My d6+ Excel Tools Druk <Ctrl> <F> om woorde te soek in hierdie artikel Hoe om die d6+ Excel Tools af te laai Kliek op die opsie wat sê "kliek hier om die d6+ Excel Apps Framework af te laai". Die lêer sal verskyn in die onderste ...Compliance Resources
My School > Compliance Type <Ctrl> <F> to search for words in the article. The DBE requires schools to submit their data on a regular basis by making use of SA-SAMS and Valistractor which are not products of d6+. We provide an opportunity to export ...Debit Order Status
Finances > Debtors > D/O Status Type <Ctrl> <F> to search for words in the article View The Debit Order Submission Status Select the month for which the debit orders were submitted at. Select applicable action date or leave it on all action dates. ...SUBJECT GROUPS
A subject group is a term we use to group learners who have different subjects together. It is therefore not for register class purposes, but for academic purposes. This feature allows the user to create subject groups and then allocate them to ...Role Based User Rights
This function enables Superusers to now set up user roles in My School > Staff > User Roles, and assign roles to staff in My School > Staff > Staff. This allows rights to be managed for groups of users at once, instead of having to apply the same ...