I have a report that has drop downs and required fields, I don't want the user to be able to save or print the document until all these cells are filled. Anyone have a sample I could follow?
I have a report that has drop downs and required fields, I don't want the user to be able to save or print the document until all these cells are filled. Anyone have a sample I could follow?
Suggest that you paste the following into the ThisWorkbook tab of te VBA editor (alt F11) and save in .xlsm format.
Adjust as necessary for the cells of interest.Please Login or Register to view this content.
Martin
May be
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Or, along the lines of mrice..
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks