hiding workbooks

does anyone know of a slick way to hide a workbook from the user. I kind of would to force the user just to use a form for all interaction. I don't care if they ever see excel.

--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/

Most simply, make the workbook an add-in and have either Auto_open or menu driven code to launch your form.

Robin Hammond
www.enhanceddatasystems.com

"Kilo Bravo" <[email protected]> wrote in message news:[email protected]...
does anyone know of a slick way to hide a workbook from the user. I kind of would to force the user just to use a form for all interaction. I don't care if they ever see excel.

--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/

make the workbook an "add-in".
"Robin Hammond" <[email protected]> wrote in message news:%[email protected]...
Most simply, make the workbook an add-in and have either Auto_open or menu driven code to launch your form.

Robin Hammond
www.enhanceddatasystems.com

"Kilo Bravo" <[email protected]> wrote in message news:[email protected]...
does anyone know of a slick way to hide a workbook from the user. I kind of would to force the user just to use a form for all interaction. I don't care if they ever see excel.

--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/

Is that a question?

If so, in Excel, save as an add-in, it is the last item in the file type list I believe.

The add-in should then be installed on each users desktop, Tools>Addins and then browse to select it and add to the list of addins.

--

HTH

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


"Kilo Bravo" <[email protected]> wrote in message news:[email protected]...
make the workbook an "add-in".
"Robin Hammond" <[email protected]> wrote in message news:%[email protected]...
Most simply, make the workbook an add-in and have either Auto_open or menu driven code to launch your form.

Robin Hammond
www.enhanceddatasystems.com

"Kilo Bravo" <[email protected]> wrote in message news:[email protected]...
does anyone know of a slick way to hide a workbook from the user. I kind of would to force the user just to use a form for all interaction. I don't care if they ever see excel.

--
K.Brown
/*****************************************************************************
To the optimist, the glass is half full.
To the pessimist, the glass is half empty.
To the engineer, the glass is twice as big as it needs to be.
******************************************************************************/

As I understand it, you have a workbook that has a form and you want to hide
the workbook and leave the form visible. Is this correct?

If yes, within the routine that shows the form, insert

Application.Visible = False

AND, in the routine where the form is unleaded, add

Application.Visible = True


"Kilo Bravo" wrote:

> does anyone know of a slick way to hide a workbook from the user. I kind of would to force the user just to use a form for all interaction. I don't care if they ever see excel.
>
> --
> K.Brown
> /*****************************************************************************
> To the optimist, the glass is half full.
> To the pessimist, the glass is half empty.
> To the engineer, the glass is twice as big as it needs to be.
> ******************************************************************************/

now, that is what I mean by "slick".

I forgot about the application object.... thanks for the reminder.



"AA2e72E" <[email protected]> wrote in message
news:[email protected]...
> As I understand it, you have a workbook that has a form and you want to
> hide
> the workbook and leave the form visible. Is this correct?
>
> If yes, within the routine that shows the form, insert
>
> Application.Visible = False
>
> AND, in the routine where the form is unleaded, add
>
> Application.Visible = True
>
>
> "Kilo Bravo" wrote:
>
>> does anyone know of a slick way to hide a workbook from the user. I kind
>> of would to force the user just to use a form for all interaction. I
>> don't care if they ever see excel.
>>
>> --
>> K.Brown
>> /*****************************************************************************
>> To the optimist, the glass is half full.
>> To the pessimist, the glass is half empty.
>> To the engineer, the glass is twice as big as it needs to be.
>> ******************************************************************************/