Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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/

  #2   Report Post  
Posted to microsoft.public.excel.programming
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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - how to se Secure FTP Ve.Bala Excel Discussion (Misc queries) 1 July 25th 09 09:56 PM
worsheet evelyne Excel Discussion (Misc queries) 2 April 13th 07 11:29 PM
Secure Information Michael Link Excel Discussion (Misc queries) 0 March 7th 06 04:03 PM
Formula for Worsheet Name Paul Sheppard Excel Discussion (Misc queries) 2 December 19th 05 04:42 PM
secure a sheet solo_razor[_25_] Excel Programming 1 November 4th 03 01:21 PM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"