Forum Discussion

MattG's avatar
MattG
Copper Contributor
Dec 08, 2021

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.    ...
Excel for web
Office Scripts
Labna's avatar
Labna
Copper Contributor
Jun 22, 2022
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.
GarryEilola's avatar
GarryEilola
Copper Contributor
Jan 17, 2023

Labna 

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.

  • NancyatMSFT's avatar
    NancyatMSFT
    Icon for Microsoft rankMicrosoft
    Jan 20, 2023
    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
    • anthonyfca's avatar
      anthonyfca
      Copper Contributor
      Sep 03, 2023
      Yes 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
    • ChadAKHill's avatar
      ChadAKHill
      Copper Contributor
      Jun 27, 2023

      NancyatMSFT 

       

      Hi - I'm sure the notification is less intrusive than before, but it's still there in bright yellow awaiting someone to tell it to go away. It would be great if either...

         a) it was as the previous user suggested and the status simply showed in the very bottom bar where averages, sums, etc show when you select cells or...

         b) it automatically disappeared a very short time after successful completion or...

         c) you had a preference option to not show it at all

       

      The biggest issue is that if you want your screen clean, you have to actively dismiss the notification.

       

      Thanks!

       

      • ChrisG2250's avatar
        ChrisG2250
        Copper Contributor
        Jun 29, 2023
        I haven't used scripts until now. The Script Run Status has immediately struck me as an issue for developing an excel based user tool. There needs to be an option to prevent this window from opening up! I'm using a script to move to a different sheet and hide the previous one (like a hyperlink but added functionality. But the Script Run Status panel opening ruins the effect.

Resources