Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
checkbox that controls macros???
Hello:
My co-workers and I have researched this issue for our client hundreds of times and we cannot seem to get an answer. We have created a macro for a few workstations. The macro is ignited from another application that exports data to Excel. After the data is dumped to Excel, the macro formats the spreadsheet and does a few other things. On that workstation--and just that workstation--two Excel spreadsheets are created. There is only supposed to be one spreadsheet. The data from the other app gets dumped into a named spreadsheet but, on this one workstation, a second spreadsheet called "Book 1" is created. It has to be something at this workstation this is causing this additional spreadsheet (Book 1) and not the macro. We have looked at everything and we have run out of ideas. Is there a setup checkbox or something like that in Excel that creates an additional spreadsheet, when a macro is run? Does anyone out there have any ideas? Thanks! childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
Can you perform Math functions with ActiveX Checkbox controls? | Excel Worksheet Functions | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
checkbox and macros | Excel Worksheet Functions |