View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bengt Nilsson, Staffanstorp, Sweden Bengt Nilsson, Staffanstorp, Sweden is offline
external usenet poster
 
Posts: 3
Default spellchecking only the unlocked cells of a protected spreadshe

If you create an Excel sheet, add the excellent macro, protect the sheet,
test if the macro spell check the unprotected cells, and then send the file
to a user that will enter data in to it.

The macro will not work since Excel standard settings for macros are;
disabled.

--
Bengt Nilsson, Staffanstorp, Sweden



"davidm" wrote:


it would be very nice if Excel could do this without any macro


Interesting reflection this one! I guess Microsoft's object is to
provide, in all cases, a "basic" tool but flexibile enough to be
modified, adapted, remodeled by the user via VBA. Which is why it is
invaluable to know one's way around VBA to some degree.


David


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=478912