View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Move a text box without allowing it to be cut

Did your macro unprotect the worksheet, move the textbox, then reprotect the
worksheet?

Trebor Retrac wrote:

Thanks Dave,
The protected sheet did not allow execution of macros.
It is a golf scoring program. I placed a commented cell in each players info
, formated the comment to show hole parameters and positioned the comment
just above the players gross scores and locked the comment. Show and Hide
comment allow for selecetive display of each comment.

Bob Carter

"Trebor Retrac" wrote:

I want to be able to drag a text box around a protected sheet but not allow
the text box to be cut.


--

Dave Peterson