Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
aaaaaaaaaaargh Help! Convert UDF to Visualbasic
I am not familiar with earlier vesrions of Excel and have an Excel 4.0
spreadsheet with some user defined functions plus macros which I would like to convert to Visualbasic. But how? I have searched the help screens and microsoft site to no avial. I can't even figure out how to get to the code for the functions etc, I am using Office 2003, it opens the spreadsheets and the UDFs work but cannot even see the code to convert. Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
aaaaaaaaaaargh Help! Convert UDF to Visualbasic
Excel 4.0 macros go on a macro sheet. Do you have one hidden
(FormatSheetsUnhide)? -- HTH RP (remove nothere from the email address if mailing direct) "aazar" wrote in message oups.com... I am not familiar with earlier vesrions of Excel and have an Excel 4.0 spreadsheet with some user defined functions plus macros which I would like to convert to Visualbasic. But how? I have searched the help screens and microsoft site to no avial. I can't even figure out how to get to the code for the functions etc, I am using Office 2003, it opens the spreadsheets and the UDFs work but cannot even see the code to convert. Please help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
aaaaaaaaaaargh Help! Convert UDF to Visualbasic
Yes! You are a scholar and a gentleman. Much obliged, thanks.
Bob Phillips wrote: Excel 4.0 macros go on a macro sheet. Do you have one hidden (FormatSheetsUnhide)? -- HTH RP (remove nothere from the email address if mailing direct) "aazar" wrote in message oups.com... I am not familiar with earlier vesrions of Excel and have an Excel 4.0 spreadsheet with some user defined functions plus macros which I would like to convert to Visualbasic. But how? I have searched the help screens and microsoft site to no avial. I can't even figure out how to get to the code for the functions etc, I am using Office 2003, it opens the spreadsheets and the UDFs work but cannot even see the code to convert. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Come selezionare solo celle con font rosso con visualbasic | Excel Discussion (Misc queries) | |||
how to track changes made to a excel sheet using VisualBasic | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Excel Visualbasic | Excel Programming |