N/APosted on - 03/06/2012
I do not know how to save the MS Excel spreadsheet created with VBA Script/buttons. Whenever I open the file, it starts in the executable mode, i. e users cannot edit the spreadsheet. So it instead forces them to use the buttons. The thing is, I don't know how.
How do I save the spreadsheet? Thanks in advance.
How to save Excel spreadsheet with VBA script
It is very easy. VBA is very important for working in Microsoft excel spreadsheet. But if someone don’t know the way of saving VBA then it’s a problem. Please follow the following instruction to know how to save VBA in Microsoft excel:
1. First go to the office button (upper of left side of computer monitor screen).
2. At there you will see lots of option. Just go to save as. Be careful don’t go to save option, its save as. If you just go there you will see a new option menu. Where lots of saving option will be available. Click on “Excel macro enable workbook” and save it.
Now your save is complete.