Software

Ask something
Discussion Locked

Excel protected template and spell check

0 helpful
4 replies

by ptaylor

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have created several templates (.xlt), in Excel 2000 that are utilized throughout our organization. In order to maintain consistentency in font size and style, along with page layout the templates are protected. When the user opens a template it converts to a spreadsheet(.xls), their addition to open cells can be very wordy. The ability to spell check the spreadsheet is not available because of protecting the template. I could create a macro that unprotects the user spreadsheet until they close it, but this will give a user access to change the fonts style, size and form layout.
I am looking for a way to where the user can open the template and add their information to the open cells, without the ability to change the form layout, then be able to spell check their spreadsheet. Currently, once a template/spreadsheet is protected the spell check option is unavailable. Any ideas on a workaround solution?

4 replies

by dklippert

Here's an idea. Write a macro that copies the data from the protected sheet. Then pastes and spell checks on an unprotected sheet. The data would then be copied and repasted in the original spot.
Here's some rough code:

Sub ProtectSpell()
Selection.Copy
Sheets("Unprotected").Select
ActiveSheet.Paste
Cells.CheckSpelling SpellLang:=1033
Application.CutCopyMode = False
Selection.Copy
Sheets("Protected").Select
ActiveSheet.Paste
ActiveCell.Next.Activate
Application.CutCopyMode = False
Selection.Copy
Sheets("Unprotected").Select
ActiveSheet.Paste
Cells.CheckSpelling SpellLang:=1033
Application.CutCopyMode = False
Selection.Copy
Sheets("Protected").Select ActiveSheet.Paste
End Sub

by ptaylor

You did a great job in pointing me in the right direction. I took the macro script you submitted and made a few changes, but without it I wouldn't have been able to fully implement the spell check with protection. Thank you so much for taking the time to set me in the right direction.

This discussion is closed to new replies.