Personal XLSB Locked For Editing?

Dec 8, 2011

I have a simple macro that's in my default Excel startup file (Personal.xlsb - located in the folder C:Documents and SettingsUsernameApplication DataMicrosoftExcelXLSTART).

The problem is when I try to open two instances of Excel (not create a new workbook). I get the error message "Personal.XLSB is locked for editing."

I've look at other threads that talk about adding the macro as an "Add-In" (Personal.xlsb and multiple Excel's), BUT my problem is that I want to assign the macro a keyboard shoutcut (currently set to ctrl + shift + v).

I don't know of a way to assign an add-in macro a keyboard shortcut.

View 7 Replies


ADVERTISEMENT

Personal.xls Locked For Editing

Dec 9, 2006

I recently added two excel files to my startup, I receive the file in use error that the personal.xls is locked for editing box when the second file starts to execute. I can open them separately using their icons with no problem, what's the problem with opening them using the startup function. XP professional version 2002 SP2.

View 9 Replies View Related

Auto Run Macro When File Is Opened But Macro Stored In Personal XLSB

Mar 4, 2014

I am looking for a macro that i can store in my personal.xlsb. what i need is pretty much is something like this

private sub workbook_open
if workbook.name "inventorysummary.csv"
then application.run "personal.xlsb!capacity"
end sub

I only need it to run just for this file and i cannot place it in the file due to it gets replaced every day. Which if it didn't get replaced. I know how to do auto opens when the file stays the same I am just unsure for this.

View 1 Replies View Related

Clearing All Tabs - Editing Locked?

Mar 20, 2013

I have an application that I made for a company. the editing is locked on each tab except for the blanks for people to either check mark a box or fill in the space provided for an answer to each question. There are around 30 tabs. Sometimes i open already completed applications since most of the answerer will be the same. My question is. is there a way to select say 6 tabs and clear out all the data that someone had typed in (check marks, answers in space provided?)

View 4 Replies View Related

File Locked For Editing - How To Unlock

Mar 15, 2012

I am getting a message, the Excel file i am opening (xlsm) is locked for editing by 'another user'. But, NOT SO, of course; i am the only user logged in to this PC, and there is no network access. I quit Excel and verified that i see no Excel processes running. But, when i try to open the file, i still get the "locked by 'another user'" message, and at this point can only open read-only. I looked in the folder the file is in and do not see any of those ~ files or anything else suspicious.

So, what do i do? How do i "unlock"? How can i open this file once again to make modifications to it?

View 7 Replies View Related

Excel 2010 :: File Is Locked For Editing?

Jun 29, 2014

I tried to open excel file from shared drive but it's pop up

"File in use" xxxx.xls is locked for editing by XXXX, Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use.

I din't know how to insert the picture so that I wrote everything.

It happens almost every time even if file has not opened by any one. how can I stop it? Version: Excel 2010. OS Name: Microsoft windows 7 professional.

View 4 Replies View Related

File Locked For Editing By 'User Name' On Save

Mar 9, 2008

i have this code to run autofilter in protected sheet2, assigned to a check Box,
but it gives me this Msg when i run the code by checking the check Box: File in use.
The file is locked for editing by the (my name). However, when i excute the code by F5 in the VBE window, it works fine also when i excute the code from Worksheet_Activate , it works fine

Sub t()
With Sheet2
. Protect "0", , , , userinterfaceonly:=True, Allowautofilter:=True
.AutoFilterMode = False
.Range("A5:DT5").AutoFilter
End With
End Sub

View 2 Replies View Related

Protect Certain Locked Cells From Editing And Allow Certain Unlocked Cells To Be Changed On Multiple Worksheets?

Jan 31, 2014

1.I need to protect certain locked cells from editing and allow certain unlocked cells to be changed on multiple worksheets.

2.When all of the changes are made to the unlocked cells, I need to password protect the entire workbook (except one worksheet) from any changes. (i.e. Prevent even the unlocked cells from being edited)

3.I also need a password to un-protect the workbook and return it to the state described in # 1. above .

View 1 Replies View Related

Linked Cells In XLSB Not Updating

Aug 7, 2014

I recently found out about .xlsb, which is faster and file size.. (mainly using it for the improved speed)

Now I've changed all the files at work to .xlsb and now link them all to .xlsm files that i can use to update the links to pull the data from the .xlsb files and then run macros as i need to.

However... I am having some issues with linked cells not updating automatically? is this because if the .xlsb format?

1. my understand was that .xlsb is the same as .xlsx just XML limitations.

2. my excel is set to automatic but i have to manually force it to update (and in some cases need to repoint the cell to the cell in the spreadsheet again).

View 4 Replies View Related

What's In Your Personal.xls

Jun 15, 2009

After using =Char(Mid(A1, 15, 1)), =Char(Mid(A1, 16, 1)), =Char(Mid(A1, 17, 1)), ... a few hundred times in years past, I made a form and wrote some code to list the contents of a cell in binary. It's been handy.

I recently added support for Unicode, so it may not be fully cooked (or maybe reheated), and double-width Unicode characters are problematic.

In addition to adding the attached form to the workbook, this needs to go in a code module.

View 14 Replies View Related

Personal.xls Won't Open

Jan 18, 2010

i can't get personal.xls to open when excel opens, i have then file both in xlstart map in the path's

C:ProgramMicrosoft OfficeOFFICE11XLSTART

and

C:Documents and SettingsjohoApplication DataMicrosoftExcelXLSTART

where "joho" is my account. i think my problem started when i added some addins

View 3 Replies View Related

Add A Function To Personal.xls

Sep 25, 2009

I have a function saved in my Personal.xls (attached) but it is returning a #NAME error when used in other sheets. I am guessing that the NAME error means that the function can't be seen by other excel woorkbooks. I have already checked the following with no result:

1. Testing the code in a different workbook.
2. The code is visible in the script editor, but personal.xls is open but hidden.
3. When I open Tools>Macro>Macros the option of "All Open workbooks" is selected from the drop downbox.
4. Macro security is on low.
5. saving the function as a .xla file and running as an add-in

View 4 Replies View Related

How To Delete Personal (.xls)

Jan 5, 2010

I have been working from help pages to try and learn and have added a personal(.xls) to my version of excel. Unfortunately I have saved some lines of code (as in the attachment screenshot) that appear to be interfering with the code that I have in some other workbooks. I cannot find a way of deleting this code or how to delete the personal(.xls) part of the VBA editor.

View 7 Replies View Related

Locate Personal.xls

Mar 16, 2006

I have installed Excel on my new computer. Went to save a macro and I cannot locate the file "Personal.Xls"

Inside of Excel I can unhide "Personal.Xls" and it is visible.

View 9 Replies View Related

Run Macro From Personal.xls

Oct 10, 2007

I have several macros set up as modules in my personal.xls. There is one particluar macro (for purposes here I will call it "SourceMacro") which I use repeatedly in other macros (also stored in personal.xls). What I have been doing is copying the code from SourceMacro and pasting it into other macros.

I understand that I can actually run the SourceMacro without pasting the code by using a run command. I have inserted the following code into one of my other macros, but get an error message saying that the SourceMacro can not be found. (I have checked spelling carefully.)

Run "Personal.xls!SourceMacro"
Excel 2003 / Windows XP

View 9 Replies View Related

Run A Macro In Personal.xls

Aug 12, 2006

I have a macro to insert rows and add formatting in personal.xls, which will run from another worksheet when using alt+ f8 with no problems.

However, I am trying to run it from a macro in the second worksheet and have tried :

Call InsertRows

and get a Compile Error: Sub or Function not defined.

Application.Run "insertrows"

and get a Runtime Error '1004': the macro '...' can not be found.

Application.Run "Personal.xls!insertrows"

and get no error message, but the rows are not inserted.

If I copy the Sub code into the new worksheet, and then use Call, everything acts as it should.

Is the third method the correct way of calling the macro, and if so, what would cause it not to do what it is supposed to do?

View 8 Replies View Related

Monving Macro From PERSONAL.XLS

Nov 21, 2008

I have (and will be) creating a number of macro in my personal workbook, a number of which will be run from within other macro also in my personal workbook. I am creating these to be distributed to members of staff within my work. This will be done by creating a template workbook for the job to be done, and e-mailing them all a copy. Now, I can not work out how to move the macro from my personal workbook into the new template so they can be run from there? Also, the macro that access other macro have a path to my personal workbook, will this be updated automatically when they are moved, or will I need to manually change them

View 3 Replies View Related

Save All Macro(s) In Personal.xls

Jan 2, 2009

I have quite a few macro's saved on my personal xls file. Anyway for me to save them with the current date to a specific folder?

e.g. MacroNameDate.bas

View 5 Replies View Related

Converting Personal.xls To Addin

Jul 7, 2009

Basically, I want to convert my Personal.xls VBAProject to say, MyMacros.xla so that I can then create a menu bar item with those addin Macros listed... I've got the code for that part ...

View 14 Replies View Related

Personal.xls Not Giving Functions

Aug 7, 2009

I referred the above two articles and accordingly created Personal.xls file in XLSTART folder. Here is the screenshot: http://dl.getdropbox.com/u/872430/excel.png I have done nothing else to the workbook except what is seen in the screenshot.
I have tested the funtion by using it as a formula in the Personal.xls file.
When I start Excel, Personal.xls does start up but the funtion is not available to my in my other workbooks. Is there anything that I have missed out?

View 4 Replies View Related

Personal.xls Is Missing In Action

Feb 25, 2008

Last friday my personal.xls file went missing. I cannot find it anywhere which means I am missing about 10 key macros. While it is not the upset of the century, my problem is that now when I go into Record Macro and try to "Store New Macro in:" -> "Personal Macro Workbook" and then click OK, Excel brings up a msg box that says:

Personal Macro Workbook in the startup folder must stay open for recording.

Click OK and Excel says:

Unable to Record

View 9 Replies View Related

Unhiding Personal Workbook

Jun 12, 2009

I search the web and found a few different instructions, however the all lead me to the same point. My unhide button is greyed out and not an option. The workbook is in the correct location on my machine, etc. For some reason I cannot unhide it and have it show in my VBA window...

View 9 Replies View Related

PERSONAL Loads Now Not Book1

Jun 6, 2006

I had made some code changes that didn't end up working as I wanted and this called for PERSONAL to be called and acted on when excel was activated. Now I have deleted the code but still on opening excel is persists in loading PERSONAL. urk. How can I go back to loading Book1 on open?

View 9 Replies View Related

Personal File Not Opening

Jun 6, 2006

I am having a problem that shouldn't be that hard to fix, but I can't seem to figure it out. I have a file in the xlstart folder, called "personal.xls" with macros in it. The security level is at low, it isn't on the disabled list, and it won't automatically open when excel opens. If I double click on it, it opens. It just won't open when excel is first started. Is there any way to correct this?

View 2 Replies View Related

Macro Run The Personal Workbook Itself

Mar 31, 2007

I am just learning a bit of VBA and developed a macro that runs fine if I used it on any workbook but when I imported it to personal.xls and tried to run it, it runs on the personal.xls itself. I tried inserting a line that activates worksheet(2) but that didn't work.

View 9 Replies View Related

Import Macro To Personal.xls

May 24, 2007

I have found several examples of excellent macro code on this site.

Is there a procedure to import a macro code ( saved as a TXT file) into the Personal.xls file?

For example, the following code removes blank spaces and converts text to proper case.

Is there an easy way to save this as a macro in my Personal.xls file?

'Macro Code to apply TRIM and PROPER functions on the selected range ..

View 8 Replies View Related

Missing Personal Macro Workbook

Aug 26, 2009

In Excel I've always had a Personal file come up when Excel was opened. It may have accidently got closed??? The personal file does not open with Excel and I am unable to find it. It is required to run macros correct?

View 13 Replies View Related

Copying Range From Personal File?

Apr 25, 2014

What I need to do is put data that I get on a variery of excel speadsheets into a standard template. I can do this by the process of copying over column by column the appropriate detail from one workbook to the other.

what I'd like to do is replicate the column headings of the template onto the workbook with the original data so I'm looking at just one workbook all the while until I'm ready to transfer all the data in one go.

I realise I can just copy from the template to the active workbook, but what I had in mind was having the ability to hit a button to replicate it associated with a macro.

So the macro I'd want would involve starting from a cell in the active workbook, obtaining a named range from my personal workbook (which would be the template headings) and then pasting this back into the active cell of the active workbook.

And if it is feasible...how would I get it to work (taking into consideration the Personal workbook may be hidden).

the only code i have at the moment is

Workbooks("PERSONAL.XLSB").Worksheets(1).Range("MODELTEMPLATE").Copy

But how would I get this to paste onto the cell I start with?

View 5 Replies View Related

Moving Personal Items To TOP Of Menu

Dec 30, 2008

One can create additional menu items for the right click, and these will show up always at the bottom. Is it possible to force them to appear at the top of the menu list above cut? This is specific to Macro created items.

View 4 Replies View Related

Creating Personal Menu Drop Down

Jul 29, 2009

I have some code to create a personal menu drop down to execute macros, which is a follows:

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved