Dear Friend,
I seek your assistance to make code for Block Save As function from my Excel file
i had one excel file for my factory but somebody makeing Save As instead of Save. this kind wrong usage makong big confusion to Data entry employees . So please help me to Block the save As opetion in excel file
thanks for your big support
By,
Nisar.mohammed
Hi Nisar.mohammed
See this link
http://www.ozgrid.com/VBA/prevent-save-as.htm
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Dear Mr. jaslake
i want to Stop Save As option .so my file cannot save to any location
Thamks for your big time & ccoperation
br,
Nisar.mohammed
Nisar,
This is what I use.
1. Open VBA and click "Workbook".
2. Set to "Workbook" and "Before Save"
3. Enter this Code:
(Obviously the Message Box Comment part is optional)
Please Login or Register to view this content.
And don't forget to collapse the VBA and protect it, otherwise someone will simply go the Code and "comment it out"!
Ochimus
Last edited by Ochimus; 05-10-2015 at 08:38 AM.
Hi Nisar
you can constraint the Save As function to your username only
in other words you can enable the Save As function for specific condition (which is here the username)Please Login or Register to view this content.
Regards
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks