TWO ISSUES: FEEDBACK SOUND WORKS INTERMITTENTLY & HOW TO DOAN EXCEL APPLICATION 'DEFAULT' FOR V

[John]

Am using a G4-400 with OXS 10.4.11 Gig of ram. Office MAC 2004, (Excel
version 11.3.5)

1. Even though I have repeatedly checked the " Provide Feedback with
Sound" box in General Preferences, often I get no sound when saving a
workbook. When I go back to the "Provide Feedback with Sound" box it is
unchecked. This happens in spite of having saved the document.
Sometimes, I get sound for a while, but sooner or later, I have this
problem some, but not all, files. NOTE. My OS sound is working correctly.





2. Is there anyway to permanently set up the Excel application to
default to "Center" for Vertical Alignment of cells, even for new
workbooks, so I don't have to do this for each new workbook?

Thanks,
John

 

[Jim Gordon MVP]

Hi John,

1. Me, too. The setting never seems to stay
2. Yes.

For #1 you could create a little add-in that runs whenever Excel opens. It
might go something like this:

Sub Autpen()
With Application
.EnableSound = True
End With
End Sub

For more information about Macros see
Using VBA with XL
http://www.mcgimpsey.com/excel/index.html

For #2 you can create a workbook that will be used as the default then save
it as a template with a .xlt file extension in the appropriate place, which
can be found by reading Excel's help topic "Create a template for workbooks
or worksheets"

-Jim

Am using a G4-400 with OXS 10.4.11 Gig of ram. Office MAC 2004, (Excel
version 11.3.5)

1. Even though I have repeatedly checked the " Provide Feedback with
Sound" box in General Preferences, often I get no sound when saving a
workbook. When I go back to the "Provide Feedback with Sound" box it is
unchecked. This happens in spite of having saved the document.
Sometimes, I get sound for a while, but sooner or later, I have this
problem some, but not all, files. NOTE. My OS sound is working correctly.





2. Is there anyway to permanently set up the Excel application to
default to "Center" for Vertical Alignment of cells, even for new
workbooks, so I don't have to do this for each new workbook?

Thanks,
John

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[John]

Thanks Jim!
******************

Hi John,

1. Me, too. The setting never seems to stay
2. Yes.

For #1 you could create a little add-in that runs whenever Excel opens. It
might go something like this:

Sub Autpen()
With Application
.EnableSound = True
End With
End Sub

For more information about Macros see
Using VBA with XL
http://www.mcgimpsey.com/excel/index.html

For #2 you can create a workbook that will be used as the default then save
it as a template with a .xlt file extension in the appropriate place, which
can be found by reading Excel's help topic "Create a template for workbooks
or worksheets"

-Jim