How can I make a certain cell in a sheet mandatory for a user to complete
Hi All,
I hope someone can help me. I have specific cells in certain sheets to be completed by the user before they can move away from the sheet. I gather that I have to build a macro for this. The one specific sheet I am referring to Cell "C103" is crucial to complete. I do have the following macro already on this sheet as follows for other functions:
Please Login or Register to view this content.
Can someone please assist me in building the new macro into the existing one?
It wouldn't be a part of the existing one. You can add another which is a Worksheet_Deactivate() event.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you sooo much,this worked perfectly.
How can I create a message which will show as soon as the user access a specific worksheet i.e to give them instructions how to complete the sheet?
Maybe:
Please Login or Register to view this content.
That works perfectly, thank you! How do I ensure that a user only sees this message the first time it visits the sheet, and not everytime when it toggles between the sheets?
You could do it by declaring a variable as public, which retains its value for the life of the application. Declarations go at the very top of a module.
If this displays once, it won't show again during that application's instance.
Please Login or Register to view this content.
daffodil11 has a better solution on the last question. This uses a helper cell in A1.
Please Login or Register to view this content.Please Login or Register to view this content.
Thank you soo much - this worked perfectly!!! I appreciate all your assistance!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks