View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Is this a form that you put on a worksheet?

If yes, select that entire range that has the outside most border.
format|cells|Border tab
Click on the top, bottom and two sides to remove the outermost border.

Undo has a limit of 16 actions, but it's resizable by tweaking a registry
setting.

xl2k and above
XL: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=211922

xl97
XL97: How to Modify the Number of Undo Levels
http://support.microsoft.com/?kbid=162944

The bad news is that that undo stack gets clobbered by lots of things--running
most macros or even doing a save will kill it.

I try to save right before I'm gonna start experimenting.


PeterM wrote:

I made a form with several individual areas that have borders. At the end I
decided to try a border around the whole form. Now that I don't like it, I
was trying to delete the form border, but it deletes all the borders in the
form as well. How can I just delete the border around the form and not the
rest of the individual borders? I'm actually on a different computer,
because of the printing, will I be able to undo my way out of it maybe, or
do I have to be on the computer where I made the form. One more question,
will the form retain the undo feature for ever, or will it stop at one point
or another? Many thanks in advance.........Peter


--

Dave Peterson