Derek
12-05-2006, 10:20 AM
I have completed 8 hours of mind numbing work. the last part of the work I was doing on a workbook was to open it from a separate workbook, select 3 sheets, print those 3 sheets and to close it down again. (Using a workbook_open sub)
Anyone spotted my problem yet?? Yes, you guessed it. the code prints out the wrong sheets, the sheets need a bit of tinkering with and stupid appearance here has it in a loop of opening, printing and closing down again!!:banghead: :bug:
is there any way I can open up this file but have the vba code not run to allow me to actually have the file open?
I feel really stupid now!!
Derek
APOLOGIES. I FIGURED IT OUT. I SET MY SECURITY TO HIGH, AND DISABLED THE MACROS.
Anyone spotted my problem yet?? Yes, you guessed it. the code prints out the wrong sheets, the sheets need a bit of tinkering with and stupid appearance here has it in a loop of opening, printing and closing down again!!:banghead: :bug:
is there any way I can open up this file but have the vba code not run to allow me to actually have the file open?
I feel really stupid now!!
Derek
APOLOGIES. I FIGURED IT OUT. I SET MY SECURITY TO HIGH, AND DISABLED THE MACROS.