View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ger[_3_] Ger[_3_] is offline
external usenet poster
 
Posts: 14
Default ActiveWorkbook.Names.Add -- Problem


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 ***