View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mfj mfj is offline
external usenet poster
 
Posts: 1
Default 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