ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007: annoying pop-up msgbox titled "Name Conflict" (https://www.excelbanter.com/excel-programming/381251-excel-2007-annoying-pop-up-msgbox-titled-name-conflict.html)

mfj

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



All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com