Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text - Remove text Item No.99 (First 2 Chars) and move to end | Excel Discussion (Misc queries) | |||
Move text | Excel Discussion (Misc queries) | |||
locking text in a cell, but allowing new text to be added | New Users to Excel | |||
Enter, tab, arrow keys aren't allowing me to move to other cells | Excel Discussion (Misc queries) |