View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hartmut \(Harry\) Kloppert Hartmut \(Harry\) Kloppert is offline
external usenet poster
 
Posts: 5
Default protecting the entire worksheet

I'm using Office 2007

Thru VBA-coding I'm protecting my worksheet so that the users
can only select and enter data into certain fields (those fields have
been unchecked for "Locked" in the Format Cells.../Protection).

At a certain event (pushbutton) I would like to have those unprotected
cells also being protected ("no more input allowed") until another "Reset"-
event/pushbutton opens up those cells again for input.

I didn't find any VBA-Help for such a coding...
Any proposal?

Harry