Thread: Prevent Save As
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Prevent Save As

You won't be able to stop them.

Heck, they could go into Windows explorer and copy that file and put it anywhere
they want.

CarlSprake wrote:

I am hoping that someone can help me with this problem.

Is there anyway to prevent a user from doing File - Save As? (preferably
using macros)

I am happy for them to make changes to a workbook, but do not want them to
be able to create different copies.

Thanks for your help


--

Dave Peterson