Forum Discussion
MattG
Dec 08, 2021Copper Contributor
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. ...
NancyatMSFT
Microsoft
Dec 21, 2021Hi 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
Thanks for asking and for this feedback!
Cheers,
Nancy on behalf of the Office Scripts team
Labna
Jun 22, 2022Copper Contributor
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.
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.
- GarryEilolaJan 17, 2023Copper Contributor
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.
- NancyatMSFTJan 20, 2023
Microsoft
Thanks all for your feedback! I wanted to share some updates on our end - since last year we've moved from showing the run status in a pane to a status bar at the top of your Excel workbooks. This change has been made fully available to customers using web versions of Excel, and we're working to make it available in desktop now as well.
Nancy- anthonyfcaSep 03, 2023Copper ContributorYes me too, I can't use these scripts to give to a user with this intrusive break to his workflow every time he runs the single line script. Nothing at all would be a suitable option, we can see instantly if the script (Refresh All) has worked or not we do not need or want any of the debug or sript status information. Please just give us an "off" button?
Many thanks
Anthony