Microsoft Office Tutorials and References
In Depth Information
Running macros when a workbook is opened
6
Click cell C11 and then, in the Macros list, click Stop Recording to stop recording
your macro.
7
In the Macros list, click View Macros to open the Macro dialog box.
8
Click Highlight , and then click Run . The macro formats the contents of cells C4 , C6 ,
and C10 in bold type.
9
On the Quick Access Toolbar , click the Save button.
10
Click the Close button to close the RunOnOpen workbook.
11
Display the Backstage view, click Recent Workbooks , and then click RunOnOpen.
xlsm . If a warning appears, click Enable Content , and then click OK to enable macros.
RunOnOpen opens, and the contents of cells C4 , C6 , and C10 change immediately to
regular type.
CLEAN UP Close the RunOnOpen workbook, saving your changes if you want to.
Search JabSto ::




Custom Search