Is it possible to have multiple active form section in one sheet of an excel book? I believe I have seen this before but have never needed to implement it until now.
So for example in one sheet they may want to see an active form giving them employee FTE information, and then in the second section they want to see an active for with expenses at an account level.
If this is possible how is it accomplished?
Multiple Active Forms
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Multiple Active Forms
Just select the insert active form button using a predefined view in perspectives.
You can right click and do it or use the active form section of the ribbon.
You can right click and do it or use the active form section of the ribbon.
Declan Rodger