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

Macros

ResolvedVersion 2007

Mon 29 Sep 2008, 16:33 Delegate Vigf said...

Vigf has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Upgrade to Office 2007 course

Macros

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

Tue 30 Sep 2008, 09:26 Trainer Carlos said...

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Macros

Macros

RE: macros

Excel articles

Excel tip:

Calculate difference between two times