Roaming / addon question

[namy77]

So I have this form to query wording of my products finishes basing on 2 criteria.

Now I wonder how I can query it from any excel workbook (perhaps as button on the ribbon) that will pop up the user form without the need of having this file open all the time or open this file when I am working on other workbooks.

Is that possible? I heard that I can save it as add-on and load it but I tried without much success.

Thanks!

[alansidman]

Put the form in your personal.xlsb file (macro file). See this link on building a Personal.xlsb file and how it works. http://www.rondebruin.nl/win/personal.htm

[namy77]

Thanks for your response - but in the file I attach the data is on a worksheet - I don't know how personal excel file can query for that even if the userform is copied over. The link is helpful but doesn't point out how to store anything but codes and forms in the personal spreadsheet. Thanks!

[MrShorty]

Even though it is hidden, the personal sheet can have as many spreadsheets as you need. If you unhide the personal sheet so that you can see and edit those sheets, then you can easily store whatever data you need to store in there, and have the VBA procedures query that data. For example, if you want to read the value in M3, a statement like

Please Login or Register  to view this content.

will take the value in M13 and store it in strvariable. Then, when you have the procedure written and debugged, you can hide personal.xlsb again, and it should work just fine.

[namy77]

So, I added the first worksheet (which has the name manager settings, data for my code). Save the personal file and test out using other files. This data does not seem to populate when I am on other worksheets? Any clue? Thanks! CWtoynx.png

[namy77]

Is there anyway to execute a code from a spreadsheet without opening it? I added buttons to run macros in any of my excel window but it keeps calling the excel worksheet that contains that code (even when it is open, it will open a second one as read-only).

Thanks!

[namy77]

Is there anyway to execute a code from a spreadsheet without opening it? I added buttons to run macros in any of my excel window but it keeps calling the excel worksheet that contains that code (even when it is open, it will open a second one as read-only).

Thanks!