$$Excel-Macros$$ Creating links to workbooks in folder using VBA

Dear Members I have a number of excel workbooks in a folder. I need to be able to have Excel check for the existance of Excel workbooks in the folder. Then using vba, write an automatic link formula from the contents of cells C1 to C20 in the files. The link formula will appear in a master wor

$$Excel-Macros$$ Selecting cutting combinations of fabric

Greetings all I have a number of widths and lengths of fabrics, up to 20 pieces. The widths and lengths can vary in size The aim is use VBA to identify the least amount of fabric I need to purchase but have the combinations fit within the width of the fabric roll, this may vary but typically coul

$$Excel-Macros$$ How to lock a worksheet based on the date?

Greetings I wish to be able to lock a workbook based on the date. I require users only to has access to the particular workbook for a specific period of time only. Hoping you can help. -- -- Some important links for

$$Excel-Macros$$ Protection of User forms in Excel

Greetings all I wish to be able to protect just one user form in an Excel VBA project but still allow users of the workbook to create macros and write code in the module section. Is this possible. When I have added a password to the user form it protect the entire project. Any assistance would be