I have a workbook with multiple worksheets. I would like to make one of those worksheets have a range of cells that are required to be filled in prior to the workbook being saved.
I also would like to create a message box that appears upon activation of the workbook.
Can anyone please help me? I've been working on this for hours!
Hi LaDonna,
Do you need all the cells to be filled in before workbook can be saved or filling in some cells in the range will allow that?
Suggest you to share the range of cells and worksheet name. If possible share the sample file as well. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi LaDonna,
Do you need all the cells to be filled in before workbook can be saved or filling in some cells in the range will allow that?
Suggest you to share the range of cells and worksheet name. If possible share the sample file as well. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Copy this into ThisWorkbook - adjust as needed...
Please Login or Register to view this content.
Last edited by dangelor; 01-11-2012 at 01:54 PM.
Well the worksheet I want to apply the code to is called INFOSHEET and the cell ranges are A3-A13. I would like a messagebox to appear that says something like "oops you forgot to enter...."
I have applied the code, but it won't let me create the macro?!? Maybe I'm doing this all wrong.
Try this...
Please Login or Register to view this content.
Thank you so much!!!! But I know this makes me sound like an idiot.... but do I need to create a macro?? Or just paste this and be done with it?Originally Posted by dangelor
Try this...
Please Login or Register to view this content.
Hi LaDonna,
Copy below code and press Alt+F11 on your Excel screen, now look for your workbook in left pane, expand the selection and double click on "This workbook". Paste below code on the right window and save.
As the code is built up, you might need to fill in the range a2: a13 to save the workbook.
Let us know if you need further help.Please Login or Register to view this content.
Regards,
DILIPandey
<click on below 'star' if this helps>
You guys are awesome! quick question... I have excel 2010 and it disables macros everytime I open it, is there a way to make sure that whoever opens the file enables their macros to open it?
you are welcome LaDonna..
Cheers
To answer your second question, Excel gives an option to user to enable / disable the macro and here user needs to simply enable them.
Regards,
DILIPandey
<click on below 'star' if this helps>
It's never stupid to question here...
The code is a macro, actually 2 of them. Just paste in the ThisWorkbook module in the VBA Project window (Alt+F11) (not in a regular code module) and they should work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks