Perhaps setting the saved property to True right after you add the name
(which is triggering the save prompt) you won't get the save prompt anymore
(unless something else is changed in the workbook after the property has been
set).
"Ger" wrote:
Hi
I use the ActiveWorkbook.Names.Add to memorize the variable value (not
visible to the user) in the excel active workbook
Ex. ActiveWorkbook.Names.Add "Name", VarName, False
but with the Excel 2000 and logon to the pc with a low level user, this
property cause a popup message
"Do you want to save the changes you made to "workbook" name"? even if I
have not made any changes to the file.
Is it possible in this case to disappear this popup?
Thanks in advanced
Ger
*** Sent via Developersdex http://www.developersdex.com ***