I've been using the Eileens Random Data Generator 4 which works great, but curios, the code points to a source sheet. ThisWorkbook.Worksheets("scrOrdList")
How can you actually see this sheet?
How to open a .xlam
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to open a .xlam
Assuming that the add-in is loaded:
Activate the Visual Basic Editor (Alt+F11).
In the Project Explorer on the left, expand the add-in and Microsoft Excel Objects under it, if necessary.
Select ThisWorkbook.
In the Properties window (press F4 if you don't see it), change the IsAddin property from True to False.
The add-in will become visible as a workbook.
When you're done, don't forget to change the IsAddin property back to True!
Activate the Visual Basic Editor (Alt+F11).
In the Project Explorer on the left, expand the add-in and Microsoft Excel Objects under it, if necessary.
Select ThisWorkbook.
In the Properties window (press F4 if you don't see it), change the IsAddin property from True to False.
The add-in will become visible as a workbook.
When you're done, don't forget to change the IsAddin property back to True!
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 254
- Joined: 09 May 2020, 14:00
Re: How to open a .xlam
Boy, now wasn't that easy. I searched all of the web for this, but was coming up empty. Thanks Hans.
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to open a .xlam
I corrected the last word in my previous reply (from False to True), but you probably suspected that already.
Best wishes,
Hans
Hans