That does not do it because you still are opening the file to get to the
macro. Is there a way to 1) show the Toolbar without using the macro OR 2)
maybe a way you set a file to open Not Visible?

Thank you for your help.

"Lee" wrote:

On Feb 2, 7:21 pm, Steven wrote:
I have a Toolbar "TBFiles" with custom buttons: There are 12 buttons down
and 5 accross = 60 total buttons. The way I open it is with a custom button
on the Standard Toolbar that when clicked opens a file and runs a macro to
show the toolbar "TBFiles" and then the excel file closes. I am a little
tired of seeing the file open and close. Is there a way to make is so when I
click the command button that the toolbar "TBFiles" will show without having
to see the excel file flash open and close.

Thank you for your help.

Steven

Use:

Application.ScreenUpdating = False

And then set it back to true before finishing your macro.