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

vba

ResolvedVersion Standard

Mariagiulia has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

VBA

Is there a way to record Codes in VBA and have access to those codes from any spreadsheets?

RE: VBA

Hi Mariagiulia

Yes there is.

You need to record the macros in the Personal Macro Workbook and then all you open Workbooks can see the code.

The Personal Macro Workbook is a hidden workbook which opens every time you open Excel.

Carlos

Excel tip:

Get to the end of the used range

What

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.