Provide feedback with sound

[Vass]

Excel 2002

I set the "provide feedback with sound" and yet, the setting never remains
after closing and re-openning Excel

How do I make this option the default setting ?

thanks

 

[Dave Peterson]

I'm not sure why it's not saving for you, but maybe you could have a little
macro that toggles that setting.

Option Explicit
Sub auto_open()
Application.EnableSound = True
End Sub

You could merge it into your existing personal.xl* file--or just create a new
workbook that contains this code (with a minor modification):

Option Explicit
Sub auto_open()
Application.EnableSound = True
ThisWorkbook.close savechanges:=false
End Sub


If you store this workbook in your XLStart folder, then excel will open that
workbook, toggle the setting to on, and close (it's served its purpose).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm