VBA query

[Closed]
Report
Posts
5
Registration date
Thursday November 29, 2012
Status
Member
Last seen
November 30, 2012
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Hello,



I'm trying to program a macro in Excell 2007. I want to put up formular for multiplying various columns and dividing eg((A5*B5)+A5)/C5). i dont want the members of the group to interfere with the formulars. It's my firs time working with VBA so any help will be appreciatted. Thanks!

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
44
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.