Excel Macro or VBA on Button

[chadlmiller]

OK this is a two part question.
First, if I can creat a button to run a Macro fine or VBA fine; which would you recommend if the Macros security issues are different between Orgs using a templated Excel spreadsheet.

Second, what I need the macro/script to Execute.
I have a data template (DATA Sheet)that the staff will complete. Once it is complete, I have three "Hidden sheets" (H1,H2,H3)

I only want the staff to use the data template to fill in the data as required. Once they complete the data it is validated manually. Once that is complete, I want three buttons:
One will run a Script on "Select" call it "AB" the script should begin to "save as" sheet "H1" as a .txt text file. tab delimited.

Second will run a Script to "Select the Button" call it "nom" And when I have done so the script should begin to "save as" sheet "H2" as a .prn file

Third will run a Script to "Select the Button" call it "dat" And when I have done so the script should begin to "save as" sheet "H3" as a .prn file

Vista windows, and Excel 2007.

Any additional information you require let me know.

 

[SkipVought]

Hi,

Macro or VBA (these terms are used interchangably) questions are best addressed in forum707.

Please repost in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}