Hi,
I have the below code for deleting all macro after my user finish saving the file as new workbook so they do not need anymore macro/VBA after. Problem is when i run to this macro it shows error 50289 project is protected. Can any one let me know how to fix this? it can be a code to unprotect the project just to enable the code?
Thank you very much --
Please Login or Register to view this content.
Hi, impresxy,
have you tried saving the workbook in FileFormat *.xlsx (xlOpenXMLWorkbook) instead of deleting the project by code?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi HaHoBe,
I have the code before that to save the file as .xlsx but I also want to delete the code out because after it saved the code is still together with the file and the user can view it. I do not want them to see.
thank you
Hi, impresxy,
maybe have a thought about the approach you have right now - to me it sounds as if you were better off by trying to use an AddIn with maybe some class programming as that would make the deleting of any code in the used workbooks obsolete. This is just my guess from what I read out from your post right now.
Ciao,
Holger
Hi,
Sorry but i am too new to use of AddIn. I have tested my file many times and sometimes there is not error ???
May be I should figure it out more so i can explain better :P
I think my problem is I protect one of the sheet. when I unprotect this sheet, the code works fine.
What about selecting all sheets and moving it to a new workbook?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You mean instead of save as new file, we move them to new workbook?.. sounds good, do you have a code for that :POriginally Posted by :) Sixthsense :)
Oops don't MOVE it, select all sheets and copy it to new workbook
Try like this....
Please Login or Register to view this content.
it's also a great idea but as i have some other function like to save the file as a specific name. To copy, then it allow my user to save as another name which i do not want to allow this. but thank you anyway, i would use it with some other excel of mine. thank you so much Sixthsense
and HaHoBe
I am unable to get your point can you please explain it little bit more?
If you save a workbook in xlsx format it cannot contain code. All you need to do after saving in that format is to close the file and the code module will be gone.I also want to delete the code out because after it saved the code is still together with the file and the user can view it.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Ahhhhh! got it! Thanks
Sorry my english is sick :P
If I copy the sheets like in your code, workbook create another file and paste all sheets I have. Then this new workbook, it allows my user to save it wherever they want and whatever name they need. I do not want to allow them to do like that. anyway it's a very useful code, thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks