98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2007
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?
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
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
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
