Workbook.Visible = True 'Makes the workbook visible.

Seems you have made a few assumptions here, Henry. Care to elaborate.


The reason your Workbook_open event is not firing is probably because the
"Enable Macros?" dialog window is opening, but you can't see it because
Excel is hidden.

don't believe this dialog shows when a workbook is opened through
automation. I have never come across it. Certainly would put a wrench in
using automation.
--
Regards,
Tom Ogilvy

Henry wrote in message
...
John,
I'm not sure what you want.
Assume that you're opening Excel as AppExcel.
AppExcel.Visible = True 'Makes Excel visible.
Workbook.Visible = True 'Makes the workbook visible.
Worksheets ("YourNameHere").Visible 'Makes the sheet visible.
The reason your Workbook_open event is not firing is probably because the
"Enable Macros?" dialog window is opening, but you can't see it because
Excel is hidden.

HTH
Henry

"John H" wrote in message
...
In Microsoft Word, using VB, I write to an Excel workbook. When I go to
Excel and load the workbook, all sheets are hiden (I can unhide). I have
been trying to find a way to unhide the workbook, either before saving it
or
when it is opened.

The Workbook.Worksheet.Visible = True does not work from Word (compile
error).

The App_WorkbookOpen sub (and other subs meant to run on opening) do not
run, I think because the workbook is hidden.

Any suggestions?

John