Hi. When I open up a workbook, I made the menu to be hidden so that users do not get to manipulate the functions. Question is this : how do code a command button to save & close the workbook once the user is done entering some data? Any help is greatly appreciated.
Hi
Please Login or Register to view this content.
Last edited by Fotis1991; 05-08-2014 at 06:30 AM. Reason: added line for close the workbook
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Fotis1991, this saves the workbook but does not close it. How do I do a close and exit? Thanks!Originally Posted by Fotis1991
OK, I tried ThisWorkbook.Close and it worked! Thanks!
You are welcome and thanks for the feed back(Also see the edited code in my first post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks