Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
We are in the process of moving to Citrix. How do I copy my macros to Citrix?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving Macro's to Citrix
Thanks!
"Jim Thomlinson" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Macros | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |