Working with matrices helps you to administer a Project Space quickly and easily. To keep the overview in a matrix we recommend to format it. Our Excel macros do the formatting for you. We offer you the following macros:
Macros for matrices
- Delete each second line.XLSB: This macro helps you to copy folder structures of a project and import it into another project (e.g. a new project).
First the macro removes all empty lines (the second lines of each folder for the Folder-Content Security) of the
- Insert empty lines.XLSB: This macro helps you to create a
If you created a folder structure in Excel (for a Folder-Permissions-Matrix each folder level needs to be in a new column) you can use this macro to insert the required empty lines for the Folder-Content Security of each folder.
If you already have a folder structure on your computer you can import it with the and export as Excel file (with every folder level in a new column). With the macro you can insert the required empty lines.
out of a folder structure which you have in an Excel file or on your computer. With the matrix you can create a new project.
- Group-Administrators-Matrix.XLSB: Group-Administrators-Matrix
- Group-Membership-Matrix.XLSB: Group-Membership-Matrix
- Folder-Properties-Matrix.XLSB: Folder-Properties-Matrix
Macros for reports
How to use a macro
- Copy the .XLSB files into the following folder on your computer:
Windows 7 + Vista: C:\Users\Your user\AppData\Roaming\Microsoft\Excel\XLSTART
Windows XP: C:\Documents and Settings\Your user\Application Data\Microsoft\Excel\XLSTART
Note: The folder AppData is often hidden or blocked by your IT Administrator. Ask your admin to get access.
- If you now open a matrix, the macro(s) are automatically loaded.
- Alternatively you can save the .XLSB files e.g. on your desktop and open it to load the macro. In this case you have to confirm in Excel that the macro is executed.
- Open the matrix which you need to edit
- Press ALT+F8 on your keyboard to call up the loaded macros. Alternatively for Windows 7 and Vista, click on "Macros" in the "View" menu and select the option "View Macros". Alternatively for Windows XP, click on "Macro" in the "Tools" menu and select the option "Macros".
- Click on the macro which you need and then on "Run".
- You matrix will be formatted now.