View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Smith[_17_] John Smith[_17_] is offline
external usenet poster
 
Posts: 39
Default Hidden sheet bleeds through

On Feb 2, 8:12*am, GS wrote:
Just a thought...
Might be a memory issue!
Have you tried using one userform with 2 frame controls that you toggle
their visibility to work like separate pages? You can have the controls
on 1st userform in Frame1 (page1) and controls on 2nd userform in
Frame2 (page2). This would also eliminate any 'cross-talk' issues
between the 2 userforms.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Thank you, Gentlemen, I really appreciate your help. I got it to work
by giving XL something else to between the unload and load processes
by having it select the sheet that it was already on. I did turn off
screen updating and used DoEvents, but those didn't work until I used
the sheet select.
James