Thread: Protecting Sheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Protecting Sheet
Paul

Good eyes. Missed that totally.

Gord Dibben XL2002

On Mon, 3 Nov 2003 19:53:43 -0500, "Paul B" wrote:

Stuart, try this, note the : after password

ActiveSheet.Protect password:="qwerty"

ActiveSheet.Unprotect password:="qwerty"

Reply With QuoteReply With Quote