Hey!
I have a sheet that uses combo boxes as pulldowns to select certain things that change numbers in text boxes. There is a picture in the backround. Whenever I change the combo boxes the page blinks. I have a macro that changes a pivottable on a separate sheet when certain boxes are changed, but included the line of code that stops it from jumping to that sheet. "Application.ScreenUpdating = False"
I do not think this is a macro problem because it happens with all the combo boxes, even the ones without macros. My guess is that it is a problem with the picture I have in the background. Maybe there is a way to imbed the picture in the backround so it doesn't refresh? I'm stuck please help if you can
.
I have a sheet that uses combo boxes as pulldowns to select certain things that change numbers in text boxes. There is a picture in the backround. Whenever I change the combo boxes the page blinks. I have a macro that changes a pivottable on a separate sheet when certain boxes are changed, but included the line of code that stops it from jumping to that sheet. "Application.ScreenUpdating = False"
I do not think this is a macro problem because it happens with all the combo boxes, even the ones without macros. My guess is that it is a problem with the picture I have in the background. Maybe there is a way to imbed the picture in the backround so it doesn't refresh? I'm stuck please help if you can
.