I have some macros that I want to use with any spreadsheet so I put them in VBAProject (Personal macro Workbook). Everything was good. Then for some reason, a new project was added and a macro was moved.
Here's the "before":
VbaProject (Budget 3.xlsm)
Microsoft Excel objects
Sheet1- 7 (Sheet name)
(there are 7 sheets to the workbook)
ThisWorkbook
(all empty)
Modules
Module 1 (empty)
Module 2 (empty)
VBAProject (Personal macro workbook)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (I think Macro 1 was here)
Modules
Module 1
thru
Module 7
(All empty except Module 3 which has macros 2 & 3.
Everything was fine then this afternoon, for some reason (I probably did something I shouldn't have), VBAProject (Personal macro Workbook (version 1).xls) was added between VBAProject (budget 3.xlsm) and VBA Project (personal workbook) and macro 1 was moved.
After:
VBSProject (budget 3.xlsm) Same as above except macro 1 was moved from personal workbook V1, to this workbook, module 1.
followed by (new)-
VBAProject (Personal macro workbook (version 1).xls) (almost identical to original)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (macro 1 was moved to module 1 of VBAProject (budget 3.xlsm)
Modules
Module 1 (empty)
Module 2 (empty)
Module 3 (macros 2 and 3)
Then VBAProject (Personal macro workbook) Same as above except macro 1 was in ThisWorkbook (I think) was moved to (Personal macro workbook)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (I think macro 1 was here)
Modules
Module 1 - 7 (empty except Module 3 which has macros 2 and 3)
Anybody know what could cause this?
If I put the macros back to where they were this morning, can I delete Workbook (Version 1)
I think there's some junk here. What can I delete to clean it up?
Thanks
Here's the "before":
VbaProject (Budget 3.xlsm)
Microsoft Excel objects
Sheet1- 7 (Sheet name)
(there are 7 sheets to the workbook)
ThisWorkbook
(all empty)
Modules
Module 1 (empty)
Module 2 (empty)
VBAProject (Personal macro workbook)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (I think Macro 1 was here)
Modules
Module 1
thru
Module 7
(All empty except Module 3 which has macros 2 & 3.
Everything was fine then this afternoon, for some reason (I probably did something I shouldn't have), VBAProject (Personal macro Workbook (version 1).xls) was added between VBAProject (budget 3.xlsm) and VBA Project (personal workbook) and macro 1 was moved.
After:
VBSProject (budget 3.xlsm) Same as above except macro 1 was moved from personal workbook V1, to this workbook, module 1.
followed by (new)-
VBAProject (Personal macro workbook (version 1).xls) (almost identical to original)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (macro 1 was moved to module 1 of VBAProject (budget 3.xlsm)
Modules
Module 1 (empty)
Module 2 (empty)
Module 3 (macros 2 and 3)
Then VBAProject (Personal macro workbook) Same as above except macro 1 was in ThisWorkbook (I think) was moved to (Personal macro workbook)
Microsoft Excel Objects
Sheet1 (Sheet1) (empty)
Thisworkbook (I think macro 1 was here)
Modules
Module 1 - 7 (empty except Module 3 which has macros 2 and 3)
Anybody know what could cause this?
If I put the macros back to where they were this morning, can I delete Workbook (Version 1)
I think there's some junk here. What can I delete to clean it up?
Thanks