Hi

I Have a funny thing
Wen I run a VBA macro with this code


Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select



But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate

I am using windows 2000 and excell 2003

Anyone have an Idea??


regards

Kurt

My first guess would be either the sheet is not visible, or screenupdating
is off, or both. Try:

Sheets("Sheet name").Select
ActiveSheet.Visible = True
'and/or
Application.ScreenUpdating = True

Mike F
"kurt" wrote in message
ups.com...
Hi

I Have a funny thing
Wen I run a VBA macro with this code


Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select



But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate

I am using windows 2000 and excell 2003

Anyone have an Idea??


regards

Kurt

Mike Fogleman skrev:

My first guess would be either the sheet is not visible, or screenupdating
is off, or both. Try:

Sheets("Sheet name").Select
ActiveSheet.Visible = True
'and/or
Application.ScreenUpdating = True

Mike F
"kurt" wrote in message
ups.com...
Hi

I Have a funny thing
Wen I run a VBA macro with this code


Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select



But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate

I am using windows 2000 and excell 2003

Anyone have an Idea??


regards

Kurt