HOw Restore Column Width

E

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
 
D

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
Click to expand...
 
E

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

Dave said:
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
Click to expand...
Click to expand...
 
D

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

Dave said:
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
Click to expand...
Click to expand...
Click to expand...
 
E

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!


Dave said:
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

Dave said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top