Spreadsheets5

Spreadsheets5 - CS170:MacrosandVBA Prof.JimAppenzeller

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 Prof. Jim Appenzeller speaker@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 simple  UDF  on the final like that found at the end of  these slides.
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 / 10

Spreadsheets5 - CS170:MacrosandVBA Prof.JimAppenzeller

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