Application.Visible = False

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SimonB - 15 Oct 2006 01:59 GMT

Hi all,
I hope that I can get help with this one.
I have a workbook with 'Application.Visible = False' in the 'Workbook
open' event, as well as 'Userform1.show'. The relevant Desktop shortcut

is set up for the application to run 'Minimized' and to start in
"C:\Program Files\Microsoft Office\OFFICE11".
In this manner, when the shortcut is Dbl clicked, the userform appears
with no visible evidence of Excel having been started. The
application.visible attribute is reset in the 'workbook close' event
with :"Application visible = true.
All of this works extremely well, however wilst previously opened
workbooks remain open and visible when I start this workbook, while the

workbook is opened I an unable to start any other excel workbook via
their shortcuts. I can however start a new instance of Excel then
browse to the workbook to open it.
MY QUESTION: How do I allow users to start any of their Excel
workbooks via their shortcuts while my application is running and the
userform showing?
Any help will be appreciated

Reply to this Message

Doug Robbins - Word MVP - 15 Oct 2006 07:42 GMT

You have posted your question concerning an issue with Excel to a Word
newsgroup. While there is some similarity between the use of VBA in both
programs, there are also some significant differences. As a result, it
would probably be better to post your question to the
microsoft.public.excel.programming newsgroup where it is far more likely to
come to the attention of people who specialise in Excel.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi all,
> I hope that I can get help with this one.
[quoted text clipped - 17 lines]
> userform showing?
> Any help will be appreciated

Reply to this Message