Hi All,
Im currently working on an excel file. i want to disable the save / Save As option in the file menu or buttons and allow saving only through a macro. Also the file should be saved only with a different name as i do not want my original file to be messed.
I tried to below code to disable saveand it worked. But when i open the original file the below code s disappeared . !!!!
Please Login or Register to view this content.
Can anyone please help me out !! ...
Thanks in Advance
Last edited by arlu1201; 08-29-2012 at 04:30 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu1201
I wasnt quiet aware of it . Thanks for the info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks