VBA query
Closed
bkaromo
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
-
Nov 30, 2012 at 08:20 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 30, 2012 at 08:47 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Nov 30, 2012 at 08:47 AM
Related:
- VBA query
- Vba case like - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba check if value is in array - Guide
- How to avoid duplicate records in sql select query - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 30, 2012 at 08:47 AM
Nov 30, 2012 at 08:47 AM
Hi bkaromo,
Please go through the below mentioned link. It has details on how to create your own formula in excel:
http://office.microsoft.com/en-in/excel-help/create-your-own-worksheet-functions-HA001054846.aspx
In order to lock your VBA program form other user's interference follow the below mentioned steps:
1. Open the VBA editor.
2. Click "Tools".
3. Select Properties for your project.
4. Click "Protection" tab.
5. Check "Lock project for viewing".
6. Enter a password to protect your project.
Please revert for clarification.
Please go through the below mentioned link. It has details on how to create your own formula in excel:
http://office.microsoft.com/en-in/excel-help/create-your-own-worksheet-functions-HA001054846.aspx
In order to lock your VBA program form other user's interference follow the below mentioned steps:
1. Open the VBA editor.
2. Click "Tools".
3. Select Properties for your project.
4. Click "Protection" tab.
5. Check "Lock project for viewing".
6. Enter a password to protect your project.
Please revert for clarification.
