Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 13
Default How to hide VB code from Excel file

Hi, I want to hide the VB code which i coded in a excel file to avoid
tampering,
Is there anyway I can protect the VB code of the file?

Any help will be appreicated
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 11,058
Default How to hide VB code from Excel file

Consider creating a password protected AddIn.
--
Gary's Student


"Anift" wrote:

Hi, I want to hide the VB code which i coded in a excel file to avoid
tampering,
Is there anyway I can protect the VB code of the file?

Any help will be appreicated

  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1,726
Default How to hide VB code from Excel file

You can password protect the VBA (in the VBIDE, ToolsPropertiesprotection
and set the password. It is not tamper-proof, but it should deter the casual
interest.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Anift" wrote in message
...
Hi, I want to hide the VB code which i coded in a excel file to avoid
tampering,
Is there anyway I can protect the VB code of the file?

Any help will be appreicated



  #4   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 13
Default How to hide VB code from Excel file

Thanks Bob and Gary, it helps

"Bob Phillips" wrote:

You can password protect the VBA (in the VBIDE, ToolsPropertiesprotection
and set the password. It is not tamper-proof, but it should deter the casual
interest.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Anift" wrote in message
...
Hi, I want to hide the VB code which i coded in a excel file to avoid
tampering,
Is there anyway I can protect the VB code of the file?

Any help will be appreicated




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
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Retaining formats grok Excel Discussion (Misc queries) 11 October 31st 06 07:29 PM
Excel updating from XML file - file path specific? Sean Excel Discussion (Misc queries) 4 August 5th 05 12:56 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 3rd 05 03:40 PM


All times are GMT +1. The time now is 07:59 AM.

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"