Thread: Allow VBA code to change a locked cell??
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
mgandrud mgandrud is offline
external usenet poster
  
Posts: 1
Default Allow VBA code to change a locked cell??

I ran into the same problem yesterday.

The following code seems to work except for sheets that have chart
objects in them.

Sheets("MySheetName").Protect UserInterfaceOnly:=True

I have found that additional arguments can be added like this:

Sheets("MySheetName").Protect UserInterfaceOnly:=True,
DrawingObjects:=False

I do not fully understand the behavior of these arguments.

I hope that this helps.


--
mgandrud
------------------------------------------------------------------------
mgandrud's Profile: 1541
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=176533

Microsoft Office Help

Reply With QuoteReply With Quote