| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Function interfering with vba
I am working on a spreadsheet that creates a vlookup to
retrieve some information for several cells. However, as the code is running, a custom function (that was there when I inherited the form, and resides in Module 1) seems to pop up and interfere with the code, though the two seem otherwise unrelated. How can I stop this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Function interfering with vba
Paula
I'd copy the function into notepad (you might want it again) then in the VBA editor choose File, Delete Module and see what happens. It might be better to backup the file first. Regards Peter -----Original Message----- I am working on a spreadsheet that creates a vlookup to retrieve some information for several cells. However, as the code is running, a custom function (that was there when I inherited the form, and resides in Module 1) seems to pop up and interfere with the code, though the two seem otherwise unrelated. How can I stop this? . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Function interfering with vba
Peter,
I did that, and the code runs perfectly, however, when I put the function back, the problem returns. The custom functions are an integral part of the spreadsheet, and without them one whole page doesn't work! I tried moving the function code to the sheet, and that doesn't work. Any other thoughts? -----Original Message----- Paula I'd copy the function into notepad (you might want it again) then in the VBA editor choose File, Delete Module and see what happens. It might be better to backup the file first. Regards Peter -----Original Message----- I am working on a spreadsheet that creates a vlookup to retrieve some information for several cells. However, as the code is running, a custom function (that was there when I inherited the form, and resides in Module 1) seems to pop up and interfere with the code, though the two seem otherwise unrelated. How can I stop this? . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom Function interfering with vba
Post the code.
In article , "posheroff" wrote: I did that, and the code runs perfectly, however, when I put the function back, the problem returns. The custom functions are an integral part of the spreadsheet, and without them one whole page doesn't work! I tried moving the function code to the sheet, and that doesn't work. Any other thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Puzzled about javascript interfering with functions and formatting | Excel Discussion (Misc queries) | |||
| Adding descriptive text to formulas without interfering w/ calcula | Excel Discussion (Misc queries) | |||
| Worksheet protection interfering with data validation combo box pr | Excel Discussion (Misc queries) | |||
| Page Protection interfering with Hiding Rows | Excel Worksheet Functions | |||
| Office XP SP3 interfering w/ Excel | Excel Discussion (Misc queries) | |||
Linear Mode
