View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default secure your worsheet using vba

The user always has the option to disable macros, so any macro based
solution could be easily overcome.

Regards,
Tom Ogilvy

"solo_razor" wrote in message
...

Hello,

I am working on a program within excel, it's almoust finished and i am
now looking for security within the worksheet.
My question: is it possible to let's say disable all of the functions
from excel with vba. e.g. that you can't save or open with the buttons,
that the menu structure won't open etc etc.

If possible has anybody got a suiteble macro for this.

Regards,
Niek


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/