I have used the following successfully for 2 years but due to an upgrade it now results in an error?
All it used to do was shut the macro sheet thus stopping anyone from 'accidentley altering' the macros enclosed in it.
Workbooks("Macros").Close savechanges :=False
I now get a runtime error
Subscript out of range
Now using excel 2003 on XP
Thanks guys
All it used to do was shut the macro sheet thus stopping anyone from 'accidentley altering' the macros enclosed in it.
Workbooks("Macros").Close savechanges :=False
I now get a runtime error
Subscript out of range
Now using excel 2003 on XP
Thanks guys