![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 04:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com