Hello,
I have a sheet in excel that has macro buttons, when pressed, each macro button transfers the name of a certain ingredient from another sheet and places it under the Ingredient name column in an Invoice sheet.
My problem is that the invoice should have a maximum of 10 ingredients and no more than that, what can I do so that only ten ingredients are allowed in the invoice sheet ?
I have an idea now but I don't know how to implement it, I want to make it only possible to press 10 buttons, and when the user tries to press the 11th button, he'll get a message
that says you cannot add any more ingredients.
EDIT: If you guys have any other ideas please share !
Thank you very much (I changed the title I hope it's good now!!!)
Bookmarks