public functions

In workbook 1 Functions - module Public Function Sheetpasswrd() Sheetpasswrd = "1234" End Function VBA Project locked for viewing etc In workbook 2 in a vba module I am moving the data from workbook 2 into workbook 1 but I need to unlock the workbook 1 In workbook 2, i can within a cell...

Hello fellow members of this forum, this is my first time posting a question, but I've been a constant reader of your posts. I'm currently working on a Min function with a conditional, if you want to check the code it works like a charm... but my problem comes when I try to make it look more...

I have a macro-enabled workbook with several modules and class modules full of code. Two modules in particular are meant as UI entry points: PublicMacros and PublicFunctions. These are the only two modules with no Option Private Module statement: PublicMacros has nothing but Public Subs with...

I would like to create a library of functions. Some of the functions will call other custom functions (to save code replication). However, I can't seem to get the functions to work together. The code is contained within one module. In the code below, the function "Prepay" works just fine...