Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.
Because you're doing a little bit of programming when you're recording a macro, there are some security settings that you need to be aware of. And we're going to review those now under the Macro Security command in the Developers tab. If you select that, it automatically opens up to your Macro Settings screen, and you have your options to disable your macros. And you might have noticed this if you've been working with other worksheets that do have macros embedded in them, when you go to open those up, you're going be asked to whether or not you want to enable or disable them.
And let's just review some of these options here. Disabling all macros without notification would be used if you don't trust macros. All macros and any documents and security alerts of macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location, and they will automatically be able to be run. But if you have any concerns at all about using macros in other spreadsheets, then this would be the selection that you would have. The default option is, Disable all macros with notification. You will be prompted whether or not you want to accept the macro in the worksheet that you're being offered that you're opening up.
And this way, you get to enable the ones on a case-by-case basis, and use those that you are very comfortable using. Next selection is disabling all macros except digitally signed macros. Now, this allows you to place a trusted publisher, and it'll always allow those particular macros to be opened without prompting. And you would put their names up here in the Trusted Publisher section. For example, Microsoft. You would always except anything that came--any macro that came--embedded in a worksheet that was signed by Microsoft.
That would be something that you can do. Finally, enable all macros, and this is not recommended because these could potentially do serious harm and damage to your code within your spreadsheet. So, powerful as macros are for saving you time, they are potentially dangerous. So always be aware when you are working with them, and very rarely go with the setting of Enable all macros.
Find answers to the most frequently asked questions about Excel 2007 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.