Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Thanks for the reply Nick. Just to let you now, I found the problem and it was quit interesting. ======== As I played around with the wb design and stuff, copying, deleting, renaming and moving sheets I somehow messed up their naming order as by its property name (not the TAB name). I noticed this as I was copying the sheets , code and modules to a blank wb (Someone on another site told me to do this) Sheet1 was sheet nr 2 in the wb (TAB named the same) then there was Sheet4 wich was sheet nr 1 in the wb (TAB named the same) then Sheet2 wich was sheet nr 3. (TAB also correct) It was wrong and/or defragmented. I renamed the sheets names to the same name as their TAB's and moved them in the same order on the Project browser as displayed in the wb view. I saved and closed and believe it or not NO error! Was it the renaming OR the Copying of the code, sheets and modules to a blank wb? that did the trick, I HAD to know I tried the same porcedure from a saved error-copy of my project. Made sure first it was still busted before I started. I copied , but did not rename, then saved and closed. Sure enough, my favoured popup blasted onto the screen. I reoped the same wb , renamed & sorted the sheets ,saved and closed. 100% OK! This was a first for me, quess that is how you learn. Thanks again, roba |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error in Excel 2007 code | Excel Discussion (Misc queries) | |||
How do I set up an Excel worksheet that compiles data from other . | Excel Worksheet Functions | |||
VB Editor compiles before I finish typing | Excel Programming | |||
Excel return error code | Excel Programming |