Suppress Printing with VBA

[hooperman]

Apologies for my error...thread edited as requested...:-

As a newbie i thought i could overcome my little problem by research and trial and error but alas,,no i am stuck

What i have is over 20 worksheets which have information on them that i want to print when selected so, i have a "main page" with a variety of options for the user to select (by check box) and when they are happy with their selection you would click another check box to print out, i have done this because the printer is set well away from the users and if they printed of sheet by sheet then lots of miles treading back and forth to the printer room would happen so, i thought by doing it this way it would batch print all selected sheets after selection, the code is set up to print all sheets which are selected by "true" in cell O2.

This is no problem as it works well but the code also prints when the check box is de selected. What I would like is a message box to appear before the main macro runs for the user to select "yes or no" to confirm printing. I have put code in this for the command but it will not run the main magro if you select "yes"...below is the code for the main print loop...I think the code for print message should appear before this...think that is..?

Please Login or Register  to view this content.

[shg]

Please take a few minutes to read the forum rules about code tags and thread titles, and then edit your post accordingly.

[hooperman]

Sorry, is this presented correctly...?

[dominicb]

Good morning hooperman

...and welcome to the forum!!

If I understand you correctly then soemthing like this should work OK :

Please Login or Register  to view this content.

HTH

DominicB

[hooperman]

Dominic.

Thanks for that, it works a treat....and after looking at the code i dunno how i missed the answer, probably because i have been looking at it too long..again, thanks all.

[hooperman]

As i mentioned in the last post the script works great and does everything that i wanted however, today there appears to be a slight problem.

The file is going to be run from a shared Network drive and can be acessed by senior managers to run as and when needed, the problem i have noticed is that whilst it works ok on my workstation it does not work on anyother PC, the error coming back is

Compile error "cannot find project or file"

Any idea's

Thanks in advance

[DonkeyOte]

On one of the PCs on which it fails you need to go to the VBE and check References - look for libraries listed as MISSING... it could be a Calendar control for ex. or it could be that your Office version is different to theirs (?) ... report back with results.

[hooperman]

Just gone into VBE (Alt F11) and looked at libraries, cannot see anything unusual, all workstations have the same version of excel as well...?

[hooperman]

For reference, the macro reports the error at this line

And LCase(Sh.Range("O2").Text) = LCase("True") Then

[DonkeyOte]

Just gone into VBE (Alt F11) and looked at libraries, cannot see anything unusual...

On the machine on which a debug is generated ?
If so I have nothing to add I'm afraid.

[hooperman]

Would anyone else have any suggestions,,,?? I really need this to work on any workstation, cannot understand why it cannot be done..


Done it..... Was errors as you said...was just me, could not find them...thanks for your help