ijourneaux
New Member
- Joined
- Jul 9, 2018
- Messages
- 36
I have a xlsm excel file with a bunch of modules and worksheets with vba code. I create a zip file (using 7-zip) with the single xlsm file in it. If I then extract the file and open it in excel, a ghost worksheet is created. IN the screen capture below, the original work sheet and worksheet macros was named Sheet25 (Results). If I place it in a zip file and extract it , the workbook gets a new worksheet object Sheet251 (Results) which doesn't have any macros. The macros are in worksheet object Sheet25. Sheet25 can not be moved and it isn't visable as a tab in the work book. And it can not be made visible.
Since the macros are nolonger with the "Results" worksheet, the macro buttons I have on that worksheet no longer work.
HAs anyone experienced this. Appreciate this is a subtle issue but any comments suggestions would be appreciated.
Since the macros are nolonger with the "Results" worksheet, the macro buttons I have on that worksheet no longer work.
HAs anyone experienced this. Appreciate this is a subtle issue but any comments suggestions would be appreciated.