VBA code to prevent printing until a named cell is updated.

[baggy098]

I had an excel file that had a piece of VBA code that brought up a box telling the user to complete a particular cell. Until the cell had been changed they were unable to print.

I can't find the file so i can't replicate it.

Can someone help with a sample of code that will do this.

Thanks

[VBA Noob]

Hi,

Can you post some more info.

Was it a cell that triggered the Input box ??

Think this code will stop a user printing

Please Login or Register  to view this content.

http://www.mcgimpsey.com/excel/modules.html


Place this event in the Thisworkbook module

This can be defeated easily by disabling macros. Also can't stop screen prints.

VBA Noob

[baggy098]

Hi

In the file I had, the user had to change a validation box from the default statement of No to Yes.

The code therefore recognised that the box had changed so allowed printing, if it wasn;t changed the message box would appear saying please update cell ?

.

Is that clearer? Cheers for the reply