Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a new Sheet in a Add-In
Hallo guys,
I have a worksheet with two tables. One empty visible table and one hidden table with shapes. I have created a function in a modul for adding a third sheet. Code: Call ThisWorkbook.Worksheets.Add(, ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.co unt)) This works fine. Now I save the XLS as an AddIn file (XLA) and call the function from a Powerpoint macro and it fails. I can step through the source code with F8, this works: msgbox ThisWorkbook.Worksheets.count The msgbox show a 2. If I call "worksheet.add" the execution aborts and next time I'm out of Excel and back in Powerpoint again. "on error resume next" statements are ignored. What ist the problem? All readOnly propertys are set to false. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a new Sheet in a Add-In
Its a MS Problem. In the File is only one Macro with one command:
http://www.gwebspace.de/peterfarge/Crash.xls Save this file as an xla and double click on the xla - crash... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |