HOw Restore Column Width

[EagleOne]

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]

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

maybe in a hidden worksheet????

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

 

[EagleOne]

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

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

maybe in a hidden worksheet????

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]

Maybe Edit|Undo.

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

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

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

maybe in a hidden worksheet????

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

 

[EagleOne]

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

Thanks Dave!

Maybe Edit|Undo.

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

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

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