I am looking for a macro that will look at cell I2 and if it is blank, prompt the user to enter information before it prints. Basically, I don't want to be able to print the sheet unless I2 has information in it. Any help would be appreciated.
I am looking for a macro that will look at cell I2 and if it is blank, prompt the user to enter information before it prints. Basically, I don't want to be able to print the sheet unless I2 has information in it. Any help would be appreciated.
Put this in the ThisWorkbook module. Replace Sheet1 with whatever sheet you are talking about. Update message to user as desired.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks