Thread: save conunderum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ted daniels ted daniels is offline
external usenet poster
 
Posts: 3
Default save conunderum

how can i put

cancel = true

in the

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As
Boolean, Cancel As Boolean)

section of the source code

when ever i do, it won't save the changes. I searched in
the old records and found a reference to
www.cpearson.com/excel/vbe.htm
but this is either too complicated for a 'newbie' like me
or it won't work. If any one can help, please do. I'm
tearing what little hair i do have, out.