Hi Forum friends
For safety, I created a backup of PERSONAL.XLS and called it PERSONAL2.XLS.
This version was saved in XLSTART by mistake! For some reason, all the macro buttons in my workbooks now point to PERSONAL2.XLS. Is there an easy way to set them back to PERSONAL.XLS? I have more than 100 buttons. I tried making a vba without success.
Many thanks for a solution
Al Jager
Last edited by ez2rmbr; 09-13-2010 at 03:58 PM.
It would be much simpler to create an addin instead of personal.xls with a proper menu
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Sorry about that Roy. Here is the same message with attachment.
I do not know about Add Ins except the ones that come with excel. Please explain how I can solve my problem with an Add Inn. For clarification, I have attached a small sample sheet.
The Run Updt button in C6 will refresh the query in E10, whereas the button in C172
will fail (there is no coresponding macro). I would like a way to reset C172 to C6 and at the same time point it to the correct library ( in this case the workbook itself)
Many thanks
Al Jager
Last edited by ez2rmbr; 09-02-2010 at 08:54 AM. Reason: insert attachment
There is no attachment
Please see the edited message above.
Al Jager
The code is actually in the example.
If the code is going to be stored in PERSONAL.xls or an addin you need to define the workbook & sheet it is to work in
Unless you intend using the same code in mutiplee workbooks why store it in PERSONAL.xls?
Please Login or Register to view this content.
Forum problem 09-01-2010
Roy, it appears that there is a misunderstanding. I know how to build the macros for my use. Since the macros will be used in multiple workbooks I have put them in C:\LocalDisk\users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS. (The official macro library for excel)
Last night excel hung up and executed a recovery. I then saved the last saved version of PERSONAL.XLS (Vesrion2) as PERSONAL.XLS.
This save overwrote the existing version. Now my buttons show that they are assigned to a library on my working HDD and the macro i.e. for update:
a. 'G:\! Dly XLS|PERSONAL.XLS'!Update
instead of
b. C:\LocalDisk\users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS
I would like a way to re-assign all my buttons from a to b.
I hope this has clarified the problem.
Al Jager
I said in the first post of mine to convert it to an addin
C:\LocalDisk\users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS. (The official macro library for excel)
Last night excel hung up and executed a recovery. I then saved the last saved version of PERSONAL.XLS (Vesrion2) as PERSONAL.XLS.
This save overwrote the existing version. Now my buttons show that they are assigned to a library on my working HDD and the macro i.e. for update:
a. 'G:\! Dly XLS|PERSONAL.XLS'!Update
instead of
entered twice
Last edited by ez2rmbr; 09-13-2010 at 03:57 PM. Reason: twice entered
I have solved the problem in this way:
1. Delete C:\LocalDisk\users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS
2. Open 'G:\! Dly XLS|PERSONAL.XLS'
3. Open the workbook where the buttons need to be reassigned.
4. Make 'G:\! Dly XLS|PERSONAL.XLS' visible then save “File as” - to:
C:\LocalDisk\users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLS
to make wkbk visible:
Sub SAVE_PERSONAL()
Windows("PERSONAL.XLS").Visible = True
End Sub
5. Close all files.
6. delete 'G:\! Dly XLS|PERSONAL.XLS'
Al
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks