I have a macro with a piece of coding in it that has always worked in the
past. It is a simple command to activate a workbook or a worksheet within a
workbook.
For example
Workbooks("VAR Calc").Activate
or Workbooks("VAR Calc").Worksheets("Historical VaR").Activate
but now when I try and run the macro I get this very strange error message
"Run time error '-2147352565 (8002000b)': Can't move focus to the control
because it is invisible, not enabled, or of a type that does not accept the
focus."
and when I debug it shows that it gets stuck on the activation code.
this is even more stragne a if I run the macro on another computer it seems
to work. Any comments will be greatfully received.