Search results for query: *

How to re-link formulas from workbooks which have been renamed and contain broken links to the current or a new workbook, assuming it is just the link which is broken but the reference sheets still exist in the workbook. Clearly this can be done using the menus but if you dont want to user to...

Hello I have a program which has been running on excel 2003 and has been migrated to 2007. Most things are working fine except. When the program is left open for a while it returns the following error. Microsoft excel canot find the following file "path\~ar28CE.xar" When the user clicks OK a...

The worksheet has a grid containing raw materials, in order to format the worksheet correctly the first cell = "." if there is data in the row otherwise it is blank. The following code then goes through each row, if the row is blank it is hidden. Other information, it is called from the...

I have an application to which I have added an option so the user can change the colours of the environment. There is a pallet down the side of the screen which is clickable and runs a proc. for changing the colours in the unlocked user entry cells of the application. I understand the maximum...

I have some code below which calculates the strength of an acid indexed against citric. However, when the code runs it does not give the right answer even though the algoritims are correct. If the same calculations are put into a spread sheet they work. here is the code and where the error...

I have a query in my worksheet. Normally when i right click on a worksheet I have code which allows me to customise the "cell" menu. This works fine everywhere. However, when i right click on the data which is the body of the query I cannot customise the "cell" menu anymore. I imagine it is...

Below are two procedures which work together to create a security key which locks a VBA Office based program to a users PC once it is run. If you want to ensure that VBA Office based software once installed on one PC cannot work on another PC then this will help. I just posted it as a thank...

I have code throughout my program which customises the right click context menu. It has always worked fine. In one sheet however it works until another event happens, then after that it doesn't wok any more. I have used the debugger to see if it was running the code, and indeed it does. It...

I have 3 tables one with the core supplier names the next with office that the core supplier could have and the third with contacts which are associated to each office. I have created a form to view the core suppliers and the offices and linked the tables to the forms. Problem. I can create...

I know that writing command bars can be a pain and very time consuming. Also there are many posts on how to do multilevel menus etc. Please find below the code for a complex multi level command bar whcih you can cut and paste into whatever you want. I have tried to structure it so it is clear...

I have been making a basic encryption module for some software I have been writing. Nothing too complicated. It comes in two parts. Part one below you place in a nex excel workbook with a uerform which allows the security/IT manager to create a key for each user of the software. The second part...

I have almost finished a program which helps beverage developers make soft drinks. I have created a help file using Help and Manual 3.3 I cannot make it so when the user pushes F1 the file automatically loads. instead the normal excel help window loads. I tried using the application.help =...

I am finishing a program for distribution and have a help file which I have compiled (.chm). I use the VB editor to attach the file to the VB project and save it, but when f1 is pushed it displays the standard excel help. What I would like to do is have the user press f1 and get the new help...

As I am having a useful afternoon this maybe helpful too lists environment variables specific to any PC the workbook is opened on. useful is you want to write algoritims to secure your application for particular users or even for particular pcs. ONLY WORKS UNDER WINDOWS NOT FOR MACS (havent...

I was getting tired of not finding the proper ids and names for the commandbar objects when I was referencing them in my code so I wrote this. It works OK not pretty but it maybe of use for someone. It outputs all commandbar controls menu name, control name and id to a blank sheet. Probably of...

pROBABLY A SILLY QUESTION BUT IS THERE SUCH A THING AS AN EXCEL RUNTIME WHICH I CAN USE TO DISTRIBUTE MY APPLICATION, IT IS WRITTEN IN EXCEL USING VBA AND IS AROUND 4.2 MEG. THANKS

I have been writing a program for about a two years and keeping it updated. I have just created a new procedure which calls a form and allows the user to edit comments in specific parts of the worksheet. I called the form Notefrm. problem is when I call it from a proc. in the main module it...

I have almost finished a program which helps beverage developers make soft drinks. I have created a help file using Help and Manual 3.3 I cannot make it so when the user pushes F1 the file automatically loads. instead the normal excel help window loads. I tried using the application.help =...