Dieter @ DWorks Posted August 9, 2006 Share Posted August 9, 2006 hey, How can you delete a worksheet? And how to select one with a specific name (or get the handle of it)? Quote Link to comment
Michael_Eschenbach Posted August 9, 2006 Share Posted August 9, 2006 If you have a worksheet on your drawing and you wish to delete it from the page, just select it and delete it..... If you wish to delete it from the file, click on the worksheet. to determine its name, look in the OIP (object info palatte). Once you know its name, go into the rescource browser and work your way down to worksheets, find the one you wish to delete and control click on it (mac), and select delete. Quote Link to comment
Dieter @ DWorks Posted August 9, 2006 Author Share Posted August 9, 2006 What i mean is how can you delete is from inside a script! Quote Link to comment
MullinRJ Posted August 9, 2006 Share Posted August 9, 2006 Funny you should ask. The same question was posted on the VS List last week. This was my answer then, and I'm sticking to it. If you have a handle to it, use DelObject(WSHnd); That should work. Also, DelObject(GetObject('WS Name'); should work if you don't yet have the handle. Raymond Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.