Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
weird things showing up on menu bar Jon Excel Discussion (Misc queries) 2 May 7th 09 09:56 PM
Textbox in userform doing weird things davegb Excel Programming 2 June 9th 06 08:01 PM
Hyperlinks doing weird things when adding columns or rows hssmith Excel Worksheet Functions 0 December 30th 05 04:21 PM
VB - Weird Things on New Computer BillCPA Excel Discussion (Misc queries) 1 July 31st 05 09:06 PM
having things happen when spreadsheet opens dan Excel Programming 3 May 6th 04 05:45 AM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"