Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 ronhansen Excel Discussion (Misc queries) 1 November 15th 09 09:33 PM
how i convert "100" to "hundred"( number to text) in excel-2007 mohanraj Excel Worksheet Functions 1 May 11th 08 09:07 PM
Excel 2007 "Name Conflict" when opening Excel 3 format goofy11 Excel Discussion (Misc queries) 0 October 15th 07 11:33 PM
Conflict with "Right" / "Left" Command DJB[_7_] Excel Programming 4 August 31st 05 10:50 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"