View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
traima traima is offline
external usenet poster
 
Posts: 23
Default Protect sheet in macro

Hi,

I have this problem; I have a worksheet that is protected, the user kan
change values in 4 spesific cells. My macro unprotects the sheet, calcualte
and protects the sheet again. Now I would like to protect the sheet so that
it will not be changed by a mistake, so that the user cannot save the changes
in the workbook.

How can I do this?

traima