Excel 2007: annoying pop-up msgbox titled "Name Conflict"
Greetings,
Problem when trying to port VBA Code from excel 2003 to Excel 2007
Beta2 which is I keep getting a pop up msgbox titled 'Name Conflict'
with in statement...
*name cannot be the same as a built in name*
* Old name: Print_area
* New Name: * textbox button here..
when activating from Excel 2007 beta2. as i remember, vba code are
running okay in excel 2003.
well, my guessing is this code, i put below code in my vba
activesheet.pagesetup.PrintArea = "somerangehere"
but.. i already make it to false at the end of code by
activesheet.pagesetup.PrintArea = False
Anyone can help me out so this annoying msgbox wont appear ?
Thanks..
mike
|