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
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 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
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.
0