Have you tried just copying your code out of your desktop version of XL and
pasting it into the personal workbook in Citrix (if I recall the ability to
have and use a personal workbook is at the Citrix admin's discression but
don't quote me on that). If that is not going to work for you then you will
probably want to change your personal workbook macro's into an addin which
you can link up to...
Have you tried just copying your code out of your desktop version of XL and
pasting it into the personal workbook in Citrix (if I recall the ability to
have and use a personal workbook is at the Citrix admin's discression but
don't quote me on that). If that is not going to work for you then you will
probably want to change your personal workbook macro's into an addin which
you can link up to...
On your desktop version just select Tools -> Macros -> Select any of your
macros in personal.xls and select Step Into. In the VBE which will open up
Click the Stop button. You are now in one of the modules of your personal.xls
file.
In Citrix write any old macro and store it in your personal workbook. Copy
the text of the macors in each of your modules on your desktop to a module in
your Citrix VBE.
On your desktop version just select Tools -> Macros -> Select any of your
macros in personal.xls and select Step Into. In the VBE which will open up
Click the Stop button. You are now in one of the modules of your personal.xls
file.
In Citrix write any old macro and store it in your personal workbook. Copy
the text of the macors in each of your modules on your desktop to a module in
your Citrix VBE.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.