Thread: Excel11.xlb
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Excel11.xlb

At some point in the closing sequence, Excel has to write that file to save
modifications. I would think it would occur after any opportunity you have
to delete the file, so as you observe, it is recreated. Although attractive,
I don't see this as a viable alternative, but someone else may have a better
idea.

--
Regards,
Tom Ogilvy




"Paul - NottsUK" wrote:

I'm trying to enforce standards on my users so I don't want them customising
fonts and icon bars. One way would be to disable the options but I have a
preference for leaving the options in place and just deleting the changes as
they exit. To do this I'm trying to delete Excel11.xlb as they exit but I
can't seem to get the code in the right place for it to trigger. One attempt
did in fact delete it only for a subsequent event in the closing excel
sequence of events to put it back. Has anyone any ideas on this?
--
Paul