Worksheet protection issues - HELP!
Hi, I am creating an excel file progrmatically . This excel file wuold get updated by a different team. After which it is again read and added in the database. The team which updates the excel should not modify certain columns and so protection and locking was used. The team however needs to run a spell check on the coulmns that are not locked. With protection, spell checking is disabled. During excel file creation spell checking cannot be run. I need to turn on spell checking option for a protected sheet? Any ideas? KPC -- kpriyac ------------------------------------------------------------------------ kpriyac's Profile: http://www.excelforum.com/member.php...o&userid=37535 View this thread: http://www.excelforum.com/showthread...hreadid=571774 |
Worksheet protection issues - HELP!
You cannot turn it on for a protected sheet.
You can use this macro to unprotect, run the spellcheck, then re-protect the sheet. Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Gord Dibben Excel MVP On Tue, 15 Aug 2006 10:12:32 -0400, kpriyac wrote: Hi, I am creating an excel file progrmatically . This excel file wuold get updated by a different team. After which it is again read and added in the database. The team which updates the excel should not modify certain columns and so protection and locking was used. The team however needs to run a spell check on the coulmns that are not locked. With protection, spell checking is disabled. During excel file creation spell checking cannot be run. I need to turn on spell checking option for a protected sheet? Any ideas? KPC Gord Dibben MS Excel MVP |
Worksheet protection issues - HELP!
ok. I am creating this excel file programatically. How would a user to able to invoke this macro. at what event should I call this macro. Can I do all this progrmatically? -- kpriyac ------------------------------------------------------------------------ kpriyac's Profile: http://www.excelforum.com/member.php...o&userid=37535 View this thread: http://www.excelforum.com/showthread...hreadid=571774 |
All times are GMT +1. The time now is 07:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com