G
Guest
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
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