LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hiden cells copied automatically to another workbook, can I stop . Fred Excel Worksheet Functions 2 April 19th 10 08:40 AM
Getting Back Hiden Columns Marilyn Excel Discussion (Misc queries) 9 October 30th 06 09:24 PM
hiden tabs & macros PG Excel Discussion (Misc queries) 2 September 1st 06 09:54 PM
Protecting A Workbook from being saved/written over Lauren Excel Discussion (Misc queries) 2 June 27th 05 06:24 PM
Why can't I unhide a hiden row JBurke Excel Discussion (Misc queries) 7 January 8th 05 03:59 PM


All times are GMT +1. The time now is 06:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"