How to save Excel spreadsheet with VBA script

Asked By dylangutierrez 10 points N/A Posted 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.

• Status: Open
• Question Views: 1197
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Oleksii bagsic 0 points N/A #195064

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.

About Oleksii bagsic

Questions
0

Answers
27

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: MS Excel