View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel Workbook hiden when written to from Word

for workbooks, the window has the visible property.

However, you probably need to make the Excel application visible

--
Regards,
Tom Ogilvy

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