Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macros

Resolved · Low Priority · Version 2007

Reply Tue 29 Nov 2011, 15:16Delegate Patricia said...

Patricia has attended:
Excel Advanced course

Macros

I set up a simple macro as a personal file. Now everytime I open a new excel sheet, it shows up a message that:"PERSONAL.XLSB is locked for editing" and asks me to choose between read only, notify, and cancel. Can this pop up be disabled?

For upcoming training course dates see: Pricing & availability

Reply Wed 30 Nov 2011, 16:39Trainer Doug said...

RE: Macros

Hi Patricia

I've just created the same message about the Personal macro file. It happens when you have two versions of Excel open at one time.

So, you can avoid the message appearing by opening your spreadsheets from within Excel. Let me know if you'd prefer to delete the Personal macro file and I'll take take you though it. Just let me know which Windows you are using.

Regards
Doug Dunn

Reply Wed 30 Nov 2011, 17:04Delegate Patricia said...

RE: Macros

Hi Doug,

Thank you for your reply.

I use several screens and always have more than one excel sheet open. Instead of opening files through "open document" on the same excel window, I open new excel windows so I can have them next to each other for a better overview.
Is there any way of resolving this? Should I delete this macro and create the same one using a different procedure to prevent the pop up from appearing?

Many Thanks,
Trish

Reply Thu 22 Dec 2011, 10:53Trainer Doug said...

RE: Macros

Hi again Trish

Perhaps it is better not to use Personal macros if you find it convenient having more than one version of Excel running.

One suggestion - Create your own macro workbook that you keep open and use instead of the Personal Macro file. You just have to remember to open it each time.

Also when opening two docs in one Excel session try right clicking on the Task bar and choosing Tile Windows vertically. See if it helps when using multiple screens.

Hope that helps.

Regards

Doug

Thu 29 Dec 2011: Automatically marked as resolved.

Excel articles

· What Do The Formula Error Messages Mean In Excel?
· What Makes A Good Spreadsheet?
· Using Headers And Footers In Excel 2010
· Data Basics Using Excel
· So Why Are There So Many File Types In Excel 2007?

Please browse our web site to find out more about
excel training in uk and other Microsoft training courses.

Excel tip:

Convert a column into row quickly in Excel 2010

Occasionally you might enter data into Excel vertically and then when you finish realize that actually it would look more clearer if it was represented in a horizontal format. If you follow these simple steps below, you can quickly change the data from going vertically to horizontally and vice versa.

First, select the column you want to convert into a row or a row into a column. Then right click and select Copy. Go to the sheet where you want to past this row as a column and select “Paste Special”. Remember to check the check-box “Transpose” and select “OK”.

View all Excel hints and tips