Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jasmine Grant   on Aug 11 In MS Office Category.

  
Question Answered By: Jimmy Abp   on Aug 11

I think the only workaround for this would be to make a macro which:

Unprotects the sheet
Runs the spellcheck
Protects the sheet.

This macro could be assigned to the existing button or a new one. You would
need a macro to run on opening the workbook to assign it and another which
ran on closing the workbook to unassign it.

I think there may be an issue that if there is an error the sheet  may be
accessible to your users  in an unprotected state. i.e. the spellcheck will
stop for the correction to be made  and the user could then do something
else.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Spellcheck in Excel Or get search suggestion and latest updates.


Tagged: