Move a text box without allowing it to be cut
 

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

Move a text box without allowing it to be cut
 

I'm not sure you can do that.

But maybe you could have a macro that asked where to put the textbox, and do the
movement in the macro.



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

Move a text box without allowing it to be cut
 

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.

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

Move a text box without allowing it to be cut
 

Thanks again Dave,
No I did not go thru the unprotect /protect process in the macro.
I think I will stick with the comment soloution, unless it does not work out
with other users of the program.
I do not want users to get to lost.

Bob Carter

"Dave Peterson" wrote:

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

Move a text box without allowing it to be cut
 

Dave,
When I finally remembered "Split Screen" it solved all my problems,

Bob Carter

"Trebor Retrac" wrote:

Thanks again Dave,
No I did not go thru the unprotect /protect process in the macro.
I think I will stick with the comment soloution, unless it does not work out
with other users of the program.
I do not want users to get to lost.

Bob Carter

"Dave Peterson" wrote:

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

Move a text box without allowing it to be cut
 

I don't like Split screen, but I use Window|freeze Panes all the time.

You may like that you can't scroll in that frozen area, too.

Trebor Retrac wrote:

Dave,
When I finally remembered "Split Screen" it solved all my problems,

Bob Carter

"Trebor Retrac" wrote:

Thanks again Dave,
No I did not go thru the unprotect /protect process in the macro.
I think I will stick with the comment soloution, unless it does not work out
with other users of the program.
I do not want users to get to lost.

Bob Carter

"Dave Peterson" wrote:

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


--

Dave Peterson