Showing related tags and posts accross the entire site.
-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
I have a very unusual problem. My workbook is fairly substantial and uses a good amount of vba/vb to handle UI issues as well as perform some calculations via UDFs. Recently I have found a situation where inter-sheet links stop working. The application allows the user to add cashflow engines - it does...
-
I want to secure macros from being edited, viewed or deleted by users. Does anyone know how to do this?
-
What is the macro command to go down to the next line?
-
Jeff It is tough to know what the answer was, but I still suspect that the wrong personal.xls or personal.xlsb was being opened. Have you tried following the steps I gave in my earlier post? If we start there, we can run through other steps if it doesn't work. Let us know
-
petedavo There should be no issue with the macros firing from a QAT button, providing the workbook is open (albeit hidden). I have suspicions that the code is in the 'wrong' personal file or you do not have it in an xlStart folder that Excel is recognising. This can vary depending on your installation...
-
Consider the following scenario. You add a macro to the Quick Access Toolbar in Microsoft Office Excel 2007. Then you close Excel 2007. Later, when you are working in Excel 2007, you click the button for a macro. In this scenario, you receive the following error message: Cannot run the macro 'macroname'...