Thread: Excel Workbook hiden when written to from Word
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John H[_4_] John H[_4_] is offline
external usenet poster
  
Posts: 9
Default Excel Workbook hiden when written to from Word
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
Reply With QuoteReply With Quote