LinkBack URL
About LinkBacks
After using two macros on 2 workbooks and saving them to the personal macro workbook; often my documents are blank when opened and I have to go to review and accessibility to view them. It's been doing this for 2 months at least often.
After using two macros on 2 workbooks and saving them to the personal macro workbook; often my documents are blank when opened and I have to go to review and accessibility to view them. It's been doing this for 2 months at least often.
How do you save two workbooks to your personal macro workbook?
When you go to start a macro; it only gives you three options. I think technically I have 4 saved under personal macro and I
can't delete two of them because it says it's on a hidden workbook. That's not a main issue though.
maybe you want to upload this file that is causing you problems so we can see what might be wrong.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
It should be attached. Under Advance A is where I have one. Thanks
This is just an xlsx - ie no code.
I presume you have a macro in your personal workbook or your "two workbooks"?
When you are recording a macro, you are asked if you want to save that macro in the personal macro workbook. The macro will not be saved in the workbook that you recorded the macro. You can run a macro from the personal macro workbook on any open workbook on your computer.
If you open the workbook from a different computer, you will not find the macro, you would have to copy the code from your personal macro workbook to the other computers personal macro workbook.
Here's the code:
Sub AdvanceA()
'
' AdvanceA Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Range("B4").Select
ActiveCell.FormulaR1C1 = "14788-115696"
Range("B4").Select
ActiveCell.FormulaR1C1 = "14788-"
Range("B5").Select
ActiveWindow.WindowState = xlMaximized
ActiveCell.FormulaR1C1 = "'14788-"
Range("B6").Select
ActiveWindow.WindowState = xlMaximized
ActiveCell.FormulaR1C1 = "14788-"
Range("B7").Select
ActiveCell.FormulaR1C1 = "14788-"
Range("B8").Select
ActiveWindow.WindowState = xlMaximized
ActiveCell.FormulaR1C1 = "14788-"
Range("B9").Select
ActiveWindow.WindowState = xlMaximized
ActiveCell.FormulaR1C1 = "14788-"
Range("B10").Select
ActiveCell.FormulaR1C1 = "14788-"
Range("B11").Select
ActiveCell.FormulaR1C1 = "14788-"
Range("D4:D11").Select
Selection.ClearContents
Range("A4:A11").Select
Selection.ClearContents
Range("A1").Select
ActiveCell.FormulaR1C1 = "Advance Auto Parts //18 statement"
Range("A2").Select
End Sub
What is the question?
After using two macros on 2 workbooks and saving them to the personal macro workbook; often my documents are blank when opened and I have to go to review and accessibility to view them. It's been doing this for 2 months at least often and don't want to be doing this.
Okay, the problem is the confusion when you say you are "saving 2 workbooks to the personal macro workbook", you don't save workbooks to the personal macro workbook, you only save macros to that workbook.
I'm trying to find a solution. Do you think that will solve it?
I found out how to delete others too because originally I couldn't delete two of them at least because it says it's on a hidden workbook.
I did not supply a solution, just a statement on why we are having issues answering the question.
That being said...
The personal macro workbook is a hidden workbook used to save macros. You should not be opening it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks