Excel Programming

Your visual blueprint for creating interactive spreadsheets

At maranGraphics, we believe in producing great computer books — one book at a time.

maranGraphics has been producing high-technology products for over 25 years, which enables us to offer the computer book community a unique communication process.

Our computer books use an integrated communication process, which is very different from the approach used in other computer books. Each spread is, in essence, a flow chart — the text and screen shots are totally incorporated into the layout of the spread. Introductory text and helpful tips complete the learning experience.

maranGraphics' approach encourages the left and right sides of the brain to work together — resulting in faster orientation and greater memory retention.

Above all, we are very proud of the handcrafted nature of our books. Our carefully-chosen writers are experts in their fields, and spend countless hours researching and organizing the content for each topic. Our artists rebuild every screen shot to provide the best clarity possible, making our screen shots the most precise and easiest to read in the industry. We strive for perfection, and believe that the time spent handcrafting each element results in the best computer books money can buy.

Thank you for purchasing this book. We hope you enjoy it!


Robert Maran

President maranGraphics

[email protected]



Acquisitions, Editorial, and Media Development

Project Editor Maureen Spears Acquisitions Editor Jen Dorsey Product Development Supervisor Lindsay Sandman Copy Editors Timothy Borek, Jill Mazurczyk Technical Editor

Allen Wyatt Editorial Manager Rev Mengle Media Development Manager Laura Carpenter VanWinkle Permissions Editor Laura Moss Media Development Specialist Angela Denny Editorial Assistants Amanda Foxworth, Jean Rogers


Book Design maranGraphics® Production Coordinator Dale White Layout

LeAndra Johnson, Adam Mancilla, Kristin Pickett, Jill Piscitelli, Erin Zeltner Screen Artists Ronda David-Burroughs, David Gregory, Mark Harris, Jill A. Proll Cover Illustration Russ Marini Proofreaders John Bitter, Susan Moritz, Carl Pierce, Christy Pingleton, Charles Spencer Indexer

TECHBOOKS Production Services Special Help Christy Pingleton, Leslie Kersey


Hungry Minds Technology Publishing Group: Richard Swadley, Senior Vice President and Publisher; Mary Bednarek, Vice President and Publisher, Networking; Joseph Wikert, Vice President and Publisher, Web Development Group; Mary C. Corder, Editorial Director, Dummies Technology; Andy Cummings, Publishing Director, Dummies Technology; Barry Pruett, Publishing Director, Visual/Graphic Design

Hungry Minds Manufacturing: Ivor Parker, Vice President, Manufacturing

Hungry Minds Marketing: John Helmus, Assistant Vice President, Director of Marketing

Hungry Minds Production for Branded Press: Debbie Stailey, Production Director

Hungry Minds Sales: Michael Violano, Vice President, International Sales and Sub Rights


Jinjer Simon has been actively involved in the computer industry for the past 17 years. Her involvement in the industry has included programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Windows CE For Dummies and Windows CE 2 For Dummies.

Jinjer and her husband live in Coppell, Texas with their two children. She currently works as a consultant for MillenniSoft, Inc., providing Web site development and online documentation development.


As an author, it is always exciting to finish the last chapter and send it to the publisher. At that point my work ends and many other individuals take on the responsibility of making sure the book actually makes it to the shelf. Because there are so many individuals involved, I am always concerned about overlooking someone. Therefore, before I thank specific individuals I would like to acknowledge the efforts of everyone at Hungry Minds who had a hand in completing the production of this book.

I really enjoyed working with the Hungry Minds team. Jen Dorsey, my acquisitions editor, did a great job of getting this project up and going, and dealing with all the little issues along the way. My project editor, Maureen Spears, was great to deal with. She was very patient as I learned how to develop using the visual blueprint style. Working along with her on the copy editing were Tim Borek and Jill Mazurczyk, who both did a great job making sure I said everything correctly. Along with them, Leslie Kersey and Amanda Foxworth helped make the process run smoothly. My technical editor, Allen Wyatt did a fantastic job of making sure the content is technically accurate.

I also want to acknowledge the efforts of the graphics and production staff who tied everything together.

I want to acknowledge my agents, Neil Salkind and David Rogelberg at Studio B, for helping me get this project. Finally, I want to thank my husband, Richard, and children, Alex and Ashley, for their patience while I completed this project.




An Introduction to Macros

Record a Macro

Create and Launch a Keyboard Shortcut

Delete a Macro from a Workbook

Delete from the Personal Macro Workbook

Assign a Macro to a Toolbar Button

Assign a Macro to a Menu

Set Macro Security

0 0

Post a comment