Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi Norman, i tried deleting the 2 parts of the code as u suggested and i got the msg "Data may exist in the sheets selected for deletion. To permanently delete the data press delete" and I had to press delete 66 times to get down to my starting 3 sheets. Also with ur last suggestion - insert the code to delete the remaining 3 unwanted sheets - my workbook will be completely empty, since the sheet 1, 2 and 3 have already been deleted. Thanks for the explanation. I will use ur code for creation and naming of the sheets then since it works with ur undo method and seems to be more flexible because of all the dims thanks again!!! -- mariasa ------------------------------------------------------------------------ mariasa's Profile: http://www.excelforum.com/member.php...o&userid=31726 View this thread: http://www.excelforum.com/showthread...hreadid=521666 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Undoing formula | Excel Discussion (Misc queries) | |||
Undoing a macro | Excel Programming | |||
undoing conditional formatting | Excel Discussion (Misc queries) | |||
Undoing LINKS in Excel 2000 | New Users to Excel | |||
undoing a VB action | Excel Programming |