Forum Discussion
Hide or close the script pane when users initiate a script from a button
Hi
I'm using a number of buttons to trigger excel online scripts in a shared workbook.
But, I don't want the users to keep seeing the scripting pane popup every time they click a button.
Anyone know of a way to close/hide the script pane when the script starts (or finishes) or prevent it from opening?
Thanks
Matt
10 Replies
- Was just trying out my first script instead of using vba, and with in 5 minutes I am searching for how to remove this bar.
With vba I can have my users click a button and it goes off and does what it needs, with scripts it gives them this progress report. I would love an option to have it only show if there was an error. Or at the very least dissappear after 2 secs on success. - To hide or close a script pane when users initiate a script from a button, you'll need to use scripting or programming, depending on the context in which you want to achieve this. Here are some general steps you can follow, but keep in mind that the exact implementation may vary depending on the software or platform you're working with:
Identify the Script Pane: Determine how the script pane is displayed or opened in your application or interface. This could be a pop-up window, a modal dialog, a separate tab, or any other interface element.
Create a Button: Ensure you have a button or user interface element that triggers the script when clicked. This button will also serve as the trigger to hide or close the script pane.
Scripting or Programming: Depending on the programming language or framework you're using, you'll need to add code to the button's action handler. The code will include instructions to initiate the script and then hide or close the script pane. - NancyatMSFT
Microsoft
Hi MattG! PM from the Office Scripts team here 🙂 This currently isn't possible though we definitely hear you that it can be frustrating to see the script pane pop up every time a user clicks a button. Out of curiosity, what would you envision the ideal experience to look like?
Thanks for asking and for this feedback!
Cheers,
Nancy on behalf of the Office Scripts team- I like to see this: Nothing unless there is an error
- This is a behavior of the online tools which irritate me too, a lot.
The behavior I'd like to see is :
- on pressing buttons you get the status of the script on the bottom bar (the one with sum of cells selected) and by clicking on the text of the status it opens the actual side panel.
- get some options in the "Automate" tab :
* checkbox "[] show/hide side panel on running scripts"
* checkbox "[] keep the scripts in the workbook" with that, the version of the script used by default is the on in the file, loaded with the reste of the document and faster to launch.
- get the possibility to launch script from trigger (leaving worksheet, click on hyperlink, cell modification...)
This way maybe the script will start faster cause it's really slow to launch.Twelve months on this still looks to be an issue, at least with locally-installed Excel. Haven't tried with the online version as yet. Would be really handy to get this resolved from a cosmetics/usability perspective. Other than that, have been able to achieve everything I've needed to with scripts so far.
