Re: $$Excel-Macros$$ Hidden sheets

2014-08-12 Thread Vaibhav Joshi
what error you are getting? If its only sheet then you cant hide it & you may get error. Cheers!! On Wed, Aug 13, 2014 at 1:43 AM, Brian wrote: > I have the following code in my Excel 2007 > > Application.Worksheets("Log").Visible = True > > and > > Application.Worksheets("Log").Visible = Fals

$$Excel-Macros$$ Hidden sheets

2014-08-12 Thread Brian
I have the following code in my Excel 2007 Application.Worksheets("Log").Visible = True and Application.Worksheets("Log").Visible = False on my own computer I have run this in Excel 2007, 2010 and 2013 without a problem - I am running on Windows 7 I have given this workbook to an associat

$$Excel-Macros$$ Hidden sheets

2009-08-26 Thread Tommy
I have not been successful in move data from one sheet to another when the destination sheet (sheet3 in this case) has been hidden using the following: Sheets ( “sheet3” ) . Visible = x1VeryHidden When I unhide sheet3 the following Macro works fine. Sub Move_Data() ' ' Move_Data Macro ' Macro