sound at end of macro in Excel

Q144. I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

To do it in Excel, here is the answer:

  1. Option Explicit
  2. Public Sub AudibleAlarm()
  3. 'Code goes here
  4. Beep
  5. End Sub

a) "Beep" command can be used to provide an audible alarm.

 

You can find similar Excel Questions and Answer hereunder

1) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

2) I frequently use a Macro - is there a way to quickly access the Macro using a Keyboard Shortcut?

3) I have a macro that takes a lot of time for execution - how can I keep the user informed that the macro is running?

4) Calling a macro from another workbook in Excel

5) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

6) How can I make my macro wait for 5 secs before executing the next command?

7) How can I add a Timestamp after macro execution?

8) How can I avoid updates to cell values during macro execution?

9) I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?

10) How can I activate a routine when there is a change in value of a cell?

11) I want to automatically run an initialization procedure whenever I open my WorkBook so that it is ready for use - how can I achieve that?

12) How can I prevent users from seeing / accessing my macro code?

13) How can I clear cell after activating a routine when there is a change in value of a cell?

14) How can I execute an event at a predetermined time from my Macro?

15) How do I assign a macro to a shape using VBA?