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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Macro

excel training course - Macro

ResolvedVersion Standard

Fri 14 Sep 2007, 16:29 Delegate Jennie said...

Jennie has attended:
Excel Intermediate course

Macro

How do I protect a macro?

Tue 25 Sep 2007, 10:56 Trainer Anthony said...

RE: Macro

Hi Jennie. If you want your code to be unavailable for alteration by others, I suggest you save the spreadsheet with your macros in as an Add-In and load that everytime Excel starts (with an AutoOpen macro). The macros will then be able to run, but the source code will be unavailable to others.

Anthony

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel training course - Macro

Macro

RE: Macro

Excel articles

Excel tip:

Closing all your workbooks Quickly