I have an Analytic App I am developing and we received a request from the product owner to prevent the user from selecting a sheet that is hidden from the user. It's worth noting that I Input this file via an Action tool which defaults to the sheet I want to input regardless of the user's sheet selection in the File Browse tool, so it doesn't really matter which sheet the user selects. However the product owner is still requesting that if a sheet is hidden from the user in the file that it be hidden from the user in the File Browse sheet selection dropdown in the App Interface.
Is it possible to prevent a File Browse tool from showing sheets that are hidden from the user in a .xlsm input file?
