Skip to main content
Snowshoeman13-Aquamarine
13-Aquamarine
August 28, 2026
Solved

Automate Collapse/Expand Areas

  • August 28, 2026
  • 2 replies
  • 76 views

Is there a way to automate the collapse or expansion of areas depending on user input above in a worksheet?  Maybe by use of JScript or Python?

Best answer by DJNewman

Unfortunately, the collapse/expand status of areas can’t be manipulated by advanced controls as of the current release.

 

The closest thing to an expansion shortcut is trying to use the find feature; it will open all non-password protected areas underneath your current clicked position on the worksheet when you try to find something. But there isn’t a way to (re)collapse them all in one go. (Nor can you multi-select areas and collapse or expand them all at once.)

2 replies

DJNewman
DJNewman19-TanzaniteAnswer
19-Tanzanite
August 28, 2026

Unfortunately, the collapse/expand status of areas can’t be manipulated by advanced controls as of the current release.

 

The closest thing to an expansion shortcut is trying to use the find feature; it will open all non-password protected areas underneath your current clicked position on the worksheet when you try to find something. But there isn’t a way to (re)collapse them all in one go. (Nor can you multi-select areas and collapse or expand them all at once.)

PTC Marketer for Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
Snowshoeman13-AquamarineAuthor
13-Aquamarine
August 28, 2026

Thanks for the reply!  I thought so but had to ask.

Terms & ConditionsAccessibility statement