Hide workbook instantly on open

[TommySzalapski]

Is it possible to hide a workbook instantly when it opens?
I currently have

Set newBook = Workbooks.Open(fileName)
Windows(fileName).Visible = False

I also tried

Set newBook = Workbooks.Open(fileName)
With newBook
.Windows(fileName).Visible = False
End With

In both cases the workbook flashes on the screen for an instant. That's clumsy. Is there a way to prevent that without saving the workbook as hidden?

Thanks

[Bob Phillips]

Tried Application.ScreenUpdating = False before it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TommySzalapski"
<[email protected]> wrote in
message news:[email protected]...
>
> Is it possible to hide a workbook instantly when it opens?
> I currently have
>
> Set newBook = Workbooks.Open(fileName)
> Windows(fileName).Visible = False
>
> I also tried
>
> Set newBook = Workbooks.Open(fileName)
> With newBook
> Windows(fileName).Visible = False
> End With
>
> In both cases the workbook flashes on the screen for an instant.
> That's clumsy. Is there a way to prevent that without saving the
> workbook as hidden?
>
> Thanks
>
>
> --
> TommySzalapski
> ------------------------------------------------------------------------
> TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
> View this thread: http://www.excelforum.com/showthread...hreadid=391021
>

[Tom Ogilvy]

Application.ScreenUpdating = False
Set newBook = Workbooks.Open(fileName)
Windows(fileName).Visible = False
Application.ScreenUpdating = True

--
Regards,
Tom Ogilvy

"TommySzalapski"
<[email protected]> wrote in
message news:[email protected]...
>
> Is it possible to hide a workbook instantly when it opens?
> I currently have
>
> Set newBook = Workbooks.Open(fileName)
> Windows(fileName).Visible = False
>
> I also tried
>
> Set newBook = Workbooks.Open(fileName)
> With newBook
> Windows(fileName).Visible = False
> End With
>
> In both cases the workbook flashes on the screen for an instant.
> That's clumsy. Is there a way to prevent that without saving the
> workbook as hidden?
>
> Thanks
>
>
> --
> TommySzalapski
> ------------------------------------------------------------------------
> TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
> View this thread: http://www.excelforum.com/showthread...hreadid=391021
>

[TommySzalapski]

Forgot about that one, thanks.
By the way, you guys should register on the forum so you can view and post at times other than 5 minutes after the hour so you don't keep answering the same questions. Not that I mind two answers... but you could help people more quickly. Just a thought.

[Tom Ogilvy]

The forum is a little pond. the big pond where most of the people asking
and answering questions are is located at

news://msnews.microsoft.com/microsof...el.programming

the forum just interfaces with the big pond.

--
Regards,
Tom Ogilvy


"TommySzalapski"
<[email protected]> wrote in
message news:[email protected]...
>
> Forgot about that one, thanks.
> By the way, you guys should register on the forum so you can view and
> post at times other than 5 minutes after the hour so you don't keep
> answering the same questions. Not that I mind two answers... but you
> could help people more quickly. Just a thought.
>
>
> --
> TommySzalapski
> ------------------------------------------------------------------------
> TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
> View this thread: http://www.excelforum.com/showthread...hreadid=391021
>

[Bob Phillips]

I don't think Tom or I will give up the NGs for a web forum. The NGs are
leaner, quicker, and better (why else would all the forums send their stuff
here).

And I don't think too many people complain about the speed of their
responses.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TommySzalapski"
<[email protected]> wrote in
message news:[email protected]...
>
> Forgot about that one, thanks.
> By the way, you guys should register on the forum so you can view and
> post at times other than 5 minutes after the hour so you don't keep
> answering the same questions. Not that I mind two answers... but you
> could help people more quickly. Just a thought.
>
>
> --
> TommySzalapski
> ------------------------------------------------------------------------
> TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
> View this thread: http://www.excelforum.com/showthread...hreadid=391021
>