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