Spell checking certain cells on a protected sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have workbook that is protected except for some certain cells.
I want to spell check only the cells that can be altered not the other cells
i also want to hide the password so that no one can find it out by looking
in the macro
Not sure when i am going to run the macro either may be on close?

please help!!
 
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.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
I have workbook that is protected except for some certain cells.
I want to spell check only the cells that can be altered not the other cells
i also want to hide the password so that no one can find it out by looking
in the macro
Not sure when i am going to run the macro either may be on close?

please help!!
Click to expand...

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
 
Back
Top