macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2007

Macros

can everybody run a excel document with a macro i have recorded.

RE: macros

Hi Vigfus

The basic answer is YES provided the following is true:

1. The macro is saved with the Excel document and NOT in your "Personal Macro Workbook"

2. Their system is set to run macros. To do this they have to:
a. Select the Tools menu and click Macro
b. Click Security
c. Select Medium in the Security dialog box (This always asks the user if they want to run the macros when a document containing macros is opened)

Hope this helps

Carlos


 

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips


Server loaded in 0.08 secs.