**Doubt**

[Rehaan Syeed]

Hi Experts,


Can we run a macro on a protected cell.......?
and how?

 

[GTO]

Most generally, yes. Set the fourth arg of .Protect to True (The UserInterfaceOnly arg)

 

[Rehaan Syeed]

Appreciate if you tell me that in detail....

 

[GTO]

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> Macro2()<br><br>    Sheet3.Protect DrawingObjects:=True, Contents:=<SPAN style="color:#00007F">True</SPAN>, Scenarios:=True, UserInterfaceOnly:=True<br>    Sheet3.Cells(1).Value = "I still got plunked in"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>