hiding workbooks

[Kilo Bravo]

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.
******************************************************************************/

 

[Robin Hammond]

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

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.
******************************************************************************/

 

[Kilo Bravo]

make the workbook an "add-in".
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

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.
******************************************************************************/

 

[Bob Phillips]

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)


make the workbook an "add-in".
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

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.
******************************************************************************/

 

[AA2e72E]

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]

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

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