ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   aaaaaaaaaaargh Help! Convert UDF to Visualbasic (https://www.excelbanter.com/excel-programming/319707-aaaaaaaaaaargh-help-convert-udf-visualbasic.html)

aazar

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.


Bob Phillips[_6_]

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.




aazar

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