HOw Restore Column Width
 

2003

When I go to formula view, the columns width expands [via VBA refit
command] to allow vewing of the entire formula.
Is there a way, in VBA to restore after Formula review, the prior
widths even if the refit command was used?


EagleOne

HOw Restore Column Width
 

If you're using code, maybe you can keep track of the original column widths?

maybe in a hidden worksheet????

EagleOne wrote:

2003

When I go to formula view, the columns width expands [via VBA refit
command] to allow vewing of the entire formula.
Is there a way, in VBA to restore after Formula review, the prior
widths even if the refit command was used?

EagleOne

--

Dave Peterson

HOw Restore Column Width
 

Kind of thought that would be a solution.

Was not sure if there was not a "go-back" type of capability other than
do-not-save.

EagleOne

Dave Peterson wrote:
If you're using code, maybe you can keep track of the original column widths?

maybe in a hidden worksheet????

EagleOne wrote:

2003

When I go to formula view, the columns width expands [via VBA refit
command] to allow vewing of the entire formula.
Is there a way, in VBA to restore after Formula review, the prior
widths even if the refit command was used?

EagleOne

--

Dave Peterson

HOw Restore Column Width
 

Maybe Edit|Undo.

But I thought you had done stuff that you didn't want to lose.

EagleOne wrote:

Kind of thought that would be a solution.

Was not sure if there was not a "go-back" type of capability other than
do-not-save.

EagleOne

Dave Peterson wrote:
If you're using code, maybe you can keep track of the original column widths?

maybe in a hidden worksheet????

EagleOne wrote:

2003

When I go to formula view, the columns width expands [via VBA refit
command] to allow vewing of the entire formula.
Is there a way, in VBA to restore after Formula review, the prior
widths even if the refit command was used?

EagleOne

--

Dave Peterson

--

Dave Peterson

HOw Restore Column Width
 

Exactly, that is why I was hoping for a plan B. Must get cracking on
storing the variables on a w/s.

Thanks Dave!


Dave Peterson wrote:
Maybe Edit|Undo.

But I thought you had done stuff that you didn't want to lose.

EagleOne wrote:

Kind of thought that would be a solution.

Was not sure if there was not a "go-back" type of capability other than
do-not-save.

EagleOne

Dave Peterson wrote:
If you're using code, maybe you can keep track of the original column widths?

maybe in a hidden worksheet????

EagleOne wrote:

2003

When I go to formula view, the columns width expands [via VBA refit
command] to allow vewing of the entire formula.
Is there a way, in VBA to restore after Formula review, the prior
widths even if the refit command was used?

EagleOne

--

Dave Peterson

--

Dave Peterson