Toolbars
 

Hi All,

I have a program that hides all the toolbars and when it is shut-down it un
hides them so the for other excel workbooks it would be fine, however on some
computers it dosen't retain the toolbars. Is there a way to make this process
work all the time every time?

Thanks in advance,

Jason Zischke

Toolbars
 

It depends on the code you are using to determine what toolbars
were visible then hidden, and the code you use to restore the
toolbars. If you are storing this information in a public
(global) variable, it is quite possible that the global variable
is getting reset, as a result of editing code, an unhandled
error, or an 'End' statement.

More details would be helpful.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jason Zischke" wrote in
message
...
Hi All,

I have a program that hides all the toolbars and when it is
shut-down it un
hides them so the for other excel workbooks it would be fine,
however on some
computers it dosen't retain the toolbars. Is there a way to
make this process
work all the time every time?

Thanks in advance,

Jason Zischke

Toolbars
 

Chip,

My code to turn the toolbars on is as follows :

Sub TurnToolbarsOn()
Application.DisplayFormulaBar = True
x = 13
Do Until x = 35
If Workbooks("Esti-log-0002.etilog").Sheets("Saving").Cells(x, 1).Value
= "" Then
Else

Application.CommandBars(Workbooks("Esti-log-0002.etilog").Sheets("Saving").Cells(x, 1).Value).Enabled = True
End If
x = x + 1
Loop
End Sub

then the code just saves and closes.


"Chip Pearson" wrote:

It depends on the code you are using to determine what toolbars
were visible then hidden, and the code you use to restore the
toolbars. If you are storing this information in a public
(global) variable, it is quite possible that the global variable
is getting reset, as a result of editing code, an unhandled
error, or an 'End' statement.

More details would be helpful.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jason Zischke" wrote in
message
...
Hi All,

I have a program that hides all the toolbars and when it is
shut-down it un
hides them so the for other excel workbooks it would be fine,
however on some
computers it dosen't retain the toolbars. Is there a way to
make this process
work all the time every time?

Thanks in advance,

Jason Zischke