If you want to set "Collapse/Expand" for all module to "None", you can go to the settings of all modules and change that in the Page settings.
But there is a way to do that by SQL:
- Log in as Host
- Go to menu item Host -> SQL
- Execute the following SQL statement (after ticking Run as script)
UPDATE {databaseOwner}{objectQualifier}TabModules
SET Visibility = 2
WHERE {databaseOwner}{objectQualifier}TabModules.IconFile IS NULL
AND {databaseOwner}{objectQualifier}TabModules.Visibility != 2
Please note that this statement will remove
all collapse/expand options from
all modules.