Spreadsheets 5

Spreadsheets 5 - CS170:MacrosandVBA KristianStout...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 170: Macros and VBA Kristian Stout stouty@rci.rutgers.edu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Expectations Macros Know that they exist and are useful VBA User Defined Functions. Be able to write a UDF for  extra credit on the final
Background image of page 2
Macros Record Macros If you are able to perform an operation manually, you can use the  macro recorder to capture that  operation View > Macros > Record Macro When finished, hit stop.  You can now use the key command to run the macro or go to the  macros screen to play the action back You could now save the workbook, but before you do so, you  should determine the file type you need and consider the  security issues covered in the next section. You can’t save the workbook as the default Excel Workbook  (*.xlsx) type. This file format does not allow macros to be  included. You can save the workbook as an Excel Macro-
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

Spreadsheets 5 - CS170:MacrosandVBA KristianStout...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online