Is there a way to disable the script confirmation popup the appears everytime I click on a button?

Wilmer Torrez 21

I create a simple file and I was trying to automate some processes and I notice that every time I click on the Script button it shows me a popup on the right side that says script run status, its annoying to see that everytime I click on the button. How do I desable that?

22610899 0 Reputation points

2023-06-16T09:02:38.46+00:00

Please can you create an option to disable the yellow status bar at the top of the worksheet when running office scripts code. it really is an eyesore and detracts from otherwise brilliant feature. This doesn't happen when running vba macros and I would like to be able to achieve the same behaviour.

I do apologize if there is already a way to do this. I would appreciate being pointed in the right direction.
ch centralmail 0 Reputation points

2023-09-03T10:48:35.5733333+00:00

yes me too, please just give us an "off" switch. We do not want ANY of the status information.

Do like the scripts idea, but cannot use it with this break in our workflow and attention.

Anthony
djk 0 Reputation points

2023-09-07T15:59:45.7+00:00

Agreed! Using buttons for automation, the script run status on the bar can show, but should disappear after a short timeout! (at least as an option)
GEORGES Paul 5 Reputation points

2023-09-29T21:48:53.5466667+00:00

Hi,

I 200% agree with this comment - it is quite annoying not being able to disable the status bar.

I'm developping an excel file for my compagny where users will have to click on a button to run a script.

It will be anoying for them to get this status bar everytime they click on this button.

I moved my macro VBA into Office Script and it will be a shame to downgrade the user experience.

If anyone find a workround please share ;)
John LS 5 Reputation points

2023-10-03T15:53:38.37+00:00

Yes please its so annoying
Rudi Koppelman 15 Reputation points

2023-12-07T10:45:51.7733333+00:00

Plz, get rid of it. (It looks more like a left over debugging option, very unproffessional)
Sevenich, Lex 15 Reputation points

2023-12-11T12:53:11.1766667+00:00

Hello Nancy,

When will this be fixed for all versions of Excel, my company wants to reprogram VBA to Scripts but this issue is very annoying and since it it around from 2020 I think there has been plenty of time to address this issue.

Sincerely Lex.
Nick Shutte | STPBrokers 0 Reputation points

2024-01-11T14:22:19.89+00:00

I see that this query was originated in February 2022, nearly two years ago. Has Microsoft not done any development to make this optional since then??
Rafael Barros Bessa 0 Reputation points

2024-08-07T21:17:55.7566667+00:00

No solution yet?
Bern 0 Reputation points

2024-09-10T11:12:31.8833333+00:00

A simple command like hide columns should not take several seconds to perform nor should it need to display its status. Keep it simple!
CCECIreland 0 Reputation points

2024-09-19T16:49:40.9466667+00:00

Macros are so fast and easy. I understand the security concern, and welcome a more secure solution, but can we really not just make it run quickly and silently like macros do?

I'm wanting to transition, but the slowness and the status bar are seriously killing me.

When will this be improved?
Builder's Logic 0 Reputation points

2024-12-22T07:18:05.67+00:00

Ironically, I come from decades writing VBA for Excel but I've started learning "Apps Script", the Google Sheets equivalent. It does the same exact annoying thing! Is this an issue with how the browser handles scripts in general? Whoever fixes it first wins my loyalty. ;-)

3 answers

Nancy Wang 116 Reputation points Microsoft Employee

2023-01-20T06:31:27.7933333+00:00

Hi David and Doug,

We've recently transitioned the status pane into a status bar at the top of the Excel workbook - this change has been fully released to Excel users who use Office Scripts on their web browser, and we're in the process of implementing it for desktop as well.

Thanks for your feedback and I hope this helps!

Warmly,

Nancy
Please sign in to rate this answer.

1 person found this answer helpful.
Chad Hill 35 Reputation points

2023-06-27T14:56:17.24+00:00

It still doesn't address that you may not want to have a notification (especially that doesn't automatically disappear) every time you run a script. For example, if you have a simple script that shows / hides infrequently used tabs...a VBA button works great for this (fast and unobtrusive) but the scripts version forces you to hide a window showing that you ran the script. Less clicks = better. Otherwise very happy with an automation tool that works across the desktop and web!

Chris Pala 21 Reputation points

2023-11-09T05:11:57.19+00:00

Same experience as Chad. I appreciate this is an improvement of the previous behaviour, but it is a huge step backwards from the legacy approach with VBA.

Delaying the run and showing the bar is a significant-enough downgrade from the VBA approach that it is stopping me from using scripts I have already written. I am not finding anything I "can't" do with a script, but further consideration around this notice is badly needed.

Rudi Koppelman 15 Reputation points

2024-01-12T10:56:09.5733333+00:00

Agree. If MS want this to be the new way to go than it needs to be seamless.
Also the script need to be embedded in the xlsx file a now we have script all over the palce. Even in my sharepoint (grr). Is there any roadmap where we can look?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Nancy Wang 116 Reputation points Microsoft Employee

2022-02-11T05:56:25.257+00:00

Hi @Wilmer Torrez ! Member of the Office Scripts team here. Though there's no current way to disable the popup, we recognize that popup is annoying to see every time and our team is actively investigating improvements. Thanks for trying our feature and bearing with us while this investigation is happening.

We really appreciate you sharing this feedback! If you have additional feedback on the script buttons experience or Office Scripts overall please feel encouraged to send that to our team by going to the Help tab in your Excel workbook and selecting "Feedback".

Warmly,
Nancy
Please sign in to rate this answer.
Kenneth Hartman 16 Reputation points

2022-09-07T22:57:02.27+00:00

Has there been any head way made on this. I'm slowly porting VBA to office scripts, and this is the biggest complaint I get, next to how slow the programs run.

DougM 10 Reputation points

2023-01-17T14:56:27.5933333+00:00

Hi Nancy,

Just to follow up on what Kenneth is requesting:
It's a seriously bad idea to allow a pop-up to show RUN STATUS every time a script runs IMO.

The user ---who doesn't know how it's coded---will not know what to do with this and will find it as annoying as the coder. Please would you ask the dev team to remove this or provide an option in the view tab to turn it off?

Kind regards,

Doug.

David Albers 5 Reputation points

2023-01-18T01:14:35.6166667+00:00

Hi Nancy,

Is there any progress on this that hasn't been posted anywhere? My org wants to start porting VBA to Office Scripts as well, but this script run status is a deal breaker for the UX. Is there a way to disable it somehow?

Ideal behavior would be to show "running script ... " in the application status bar somewhere - anywhere less obtrusive than 1/3 of the screen being hidden by the confusing status pane. End users just want to see the results, not internal messages like this.

Thanks,

David.

BrainStain00 5 Reputation points

2023-06-19T15:07:54.04+00:00

It may be annoying, but I have found it useful, so that any from my team of 10 wont try to run their script at the same time someone else is running theirs. Each script has over 300 actions and takes about 5-15 seconds to run, so the script is at least giving a warning its running, so that others wont crash that run by interrupting it. The 3 prompts it gives is an alert to others to wait until its finished. Just my 2 cents on the positive side.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
tao 0 Reputation points

2024-04-22T18:26:39.0333333+00:00
"There! I fixed it!" (old school way)

Instead of using the shortcuts provided in the Automation section of the ribbon...

Go to the Developer section (you may need to display it first):

Code a macro yourself:

Back in your worksheet, insert a button (it won't show until you draw your button area somewhere on the sheet):

Select your macro to associate it with it:

You're done with all the "let's make it easier for you" nonsense.
Please sign in to rate this answer.
Sevenich, Lex 15 Reputation points

2024-04-23T08:31:49.82+00:00

How will this help when running a script?

Edward Gray 10 Reputation points

2024-07-12T12:26:28.5933333+00:00

Still no fix for this? Come on Microsoft, it cannot be THAT hard to have a toggle to disable the popup. And no, Macros aren't an option as macro-enabled workbooks aren't compatible with Microsoft Power Automate bizarrely.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Is there a way to disable the script confirmation popup the appears everytime I click on a button?

3 answers

Your answer