View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sethaholic[_29_] Sethaholic[_29_] is offline
external usenet poster
 
Posts: 1
Default Prevent someone from renaming a workbook


Hi,

I programmed a macro that disables the "save as" function so that user
won't be able to "save as" and rename the workbook to something els
(for security purposes).

However, users can still rename it manually outside the workbook. I
there a way that I can program something in VBA or somewhere else t
prevent users from manually renaming a workbook?

Many thanks!!

--
Sethaholi
-----------------------------------------------------------------------
Sethaholic's Profile: http://www.excelforum.com/member.php...fo&userid=2511
View this thread: http://www.excelforum.com/showthread.php?threadid=56753