Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
weird things happen sometimes
i was wondering if anyone else sees things like this:
1. i will have some code that formats a cell a certain color. i change the value it works fine. i change to another color, it doesn't change. i even put a breakpoint in the code so i could see if it skips it, it never even stopped executing. i then put the breakpoint on the sub line, clicked the menu button, code ran fine, didn't stop, and had the wrong color. changed the line of code right before the color to change the value of the cell, then it changed the color to the correct color. 2. with pagesetup code, i'll change the values of the margins, they'll change once or twice, then no matter what value i set, the margins never change. move that line of code to a different location under with pagesetup, and the margin is changed. 3. did the same thing with a graphic header. wouldn't appear. moved it down a few lines and it works. it's as if all the code is stored in the cache and doesn't refresh the changes i make in the vbe. happens with forms designs, too. does anyone else see these types of things? -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird things showing up on menu bar | Excel Discussion (Misc queries) | |||
Textbox in userform doing weird things | Excel Programming | |||
Hyperlinks doing weird things when adding columns or rows | Excel Worksheet Functions | |||
VB - Weird Things on New Computer | Excel Discussion (Misc queries) | |||
having things happen when spreadsheet opens | Excel Programming |