Hiding another workbook with vba...

Posted by RoB on October 11, 2001 5:04 PM

I have a workbook that when opened, opens another workbook used with it using a macro. I was wondering how i would HIDE the 2nd workbook from the user (not allow them to see or edit it) using vba. I know you can do it with the workspace way ( i think) but i'd like to use vba if possible. thanks :)

Posted by Robb on October 12, 2001 4:25 AM

Rob

Try the "Visible" property of the Workbook Windows:

Windows("Mybook.xls").Visible = False

The workbook will not be visible, nor will it be listed
in the Window list.

To make it visible again, just change the False to True.

Any help?

Regards

Robb