Jump to content
MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. ×

Excel macro so workbook can't get advanced to the next page

Recommended Posts

I am trying to implement a macro in Excel so that when certain cells are not filled in the worksheet pops up an error saying they must be filled in before the user advances to the next worksheet in the workbook. I tried to do this with data validation in Excel, but I would like to save the worksheet with a blank cell and have the error message come up after the user worksheet is being used, not when I am editing it. In other words, I can't leave the cell blank after deleting data from it because I get the same error that the users would get.

We want the sheet to work like a web site that requires certain fields to be filled in.

I figure that I need to use a macro to accomplish what I'm trying to but perhaps not? Thanks in advance!

Edited by buckdog05
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...