secure your worsheet using vba
 

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/

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/