View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Moving Macro's to Citrix

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.

--
HTH...

Jim Thomlinson


"lk" wrote:

Where do I find the personal workbook?

"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"lk" wrote:

my personal workbook

"Jim Thomlinson" wrote:

Are you talking about addins or your personal workbook (personal.xls) or...
--
HTH...

Jim Thomlinson


"lk" wrote:

We are in the process of moving to Citrix. How do I copy my macros to Citrix?