Forum home » Delegate support and help forum » Microsoft Excel Training and help » PERSONAL file defaulting to .xlsb

PERSONAL file defaulting to .xlsb

ResolvedVersion 2007

Fri 11 Nov 2011, 15:40 Delegate Lisa said...

Lisa has attended:
Excel Advanced course

PERSONAL file defaulting to .xlsb

Hi

Is there a way to change the default setting so that when I create a macro it defaults to save as .xlsm rather than .xlsb? at the moment it automatically saves as a binary file and I can't see a way to change it.

thanks

Lisa

Fri 18 Nov 2011, 09:47 Trainer Simon said...

RE: PERSONAL file defaulting to .xlsb

Hi Lisa,

Thank you for your question.

You can change the default setting for a workbook to *.xlsm via the Office button and then Excel options. However, this will apply to all workbooks saved in your current session.

Office button - Save option on the left hand side - Change the Save file format to macro enabled workbook.

I hope this helps.

Regards

Simon

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

PERSONAL file defaulting to .xlsb

PERSONAL file defaulting to .xlsb

RE: PERSONAL file defaulting to .xlsb

Excel articles

Excel tip:

Difference between Two Dates