I think you're concerned that since the sheet must be unprotected in order to run the spell
check, and the macro must do the unprotecting, then anyone viewing the macro can get to the
password.  True.  You can protect the macro with Tools - VBA Project properties - Protection
tab.  Check the "Lock project for viewing" box.  Now any time you want to work with the
macros, you'll be prompted for the password.  Note that it remains locked -- the next time
the workbook is opened, the password will be required again.  It's said that this password
is more secure than the password to open a workbook, for which there are password crackers
on every street corner of the internet.

On 3 Jul, 14:24, ExcelDummie <ExcelDum...@discussions.microsoft.com>
wrote:

Hi ED

As well as protecting your book's project with a password, you might
want to also consider using something like this in the Workbook_Open
event:

For Each sht In Worksheets
   sht.Protect password:=MyPassword, userinterfaceonly:=True
Next

Userinterfaceonly:=True allows macros to ignore password protection
for that workbook.

Regards

Steve