FM - Can You Use Conditional Formatting to Hide a Tab Panel?
I have two processes that overlap a lot - Surrenders and Leases, so when I added Surrenders, I just put it on a different tab instead of a different layout. However, I want to be sure that data entry staff do not enter anything on the Surrender tab, if it is a lease and vice versa other than what is above the tabs.
Currently, I use conditional formatting on a field that covers almost the entire tab that functions as a WARNING. However, is there a way to use conditional formatting to just make the other tab invisible if you don't want them entering any info on it? I right clicked, but conditional formatting is not an option for each tab. If not, how else would you do it?
Currently, I use conditional formatting on a field that covers almost the entire tab that functions as a WARNING. However, is there a way to use conditional formatting to just make the other tab invisible if you don't want them entering any info on it? I right clicked, but conditional formatting is not an option for each tab. If not, how else would you do it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Will Loving
Just realized there is a typo in my note, it should have said "since you can't do conditional formatting..."
ASKER
Will, normally would like your suggestion, but my users get thrown off by a new window. Will use a combo of scripting to prevent navigation to the other tab based on the Lease Ops and covering the tab. Note to myself: remember when scripting tab panels to add the object name to the tab properties. This is different than the name you give the tab.