+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date

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

    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.


  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)

    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.

    Place this event in the Thisworkbook module

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

    VBA Noob

    Credo Elvem ipsum etian vivere
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1